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

Which database stores information about replication?

732


What are the steps you will take to improve the performance of a poor performing query?

762


Determine when to use stored procedure to complete sql server tasks?

715


List few advantages of stored procedure.

725


What are the types of normalization?

713






Does union all remove duplicates?

805


List out what other servers you can use with ssrs?

115


How to connect to a sql server using odbc_connect()?

837


What is correlated subquery in sql server?

748


What are indexers?

809


How we can compare two database data?

687


How to delete a database in ms sql server?

726


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

696


How do I find the sql server database version?

688


What are trace flags and mention a few common trace flags used with sql server?

752