How to genrate automaticlly empid like gt001

Answer Posted / trainedforjob

create a identity column and create a computed column which will br 'gt' concatenate identity column

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain syntax for viewing, dropping and disabling triggers?

495


Explain the dirty pages?

566


How does clustered and non clustered index work?

509


Explain difference between control flow and data flow?

522


What are the types of dml?

545






Define magic tables in sql server?

562


What is an execution plan?

561


Difference between Sql server reporting services and Crystal reports?

124


What is a with(nolock)?

569


What is the guest user account in sql server? What login is it mapped to it? : sql server security

577


Do you know the capabilities of cursors?

529


What command would you use to add a column to a table in sql server?

740


How to create view in stored procedure sql server?

498


Explain few examples of RDBMS?

609


Do you think BCNF is better than 2NF & 3NF? Why?

776