create a identity column and create a computed column which will br 'g

How to genrate automaticlly empid like gt001

Question Posted / trainedforjob

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

Please Help Members By Posting Answers For Below Questions

Explain the ways to controlling cursor behavior?

876

what are the different stages of Report Processing?

125

What are the extra roles available in msdb? : sql server security

1078

What are different types of join?

1238

How does using a separate hard drive for several database objects improves performance right away?

886

How do you run a trace?

850

What is trace flag in sql server?

977

How to connect sql server management studio express to sql server 2005 express?

969

what is sql server? : Sql server database administration

930

What is rank function?

978

How to drop an existing table with "drop table" statements in ms sql server?

1038

What is the use of partition by in sql server?

884

What are the recovery models in sql server 2000?

927

Delete duplicate rows without using rowid.

1493

How can you start sql server in different modes?

925