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

How to use union to merge outputs from two queries together in ms sql server?

1054

How can I get data from a database on another server?

979

New concepts of sql server 2005 use in your project.

2354

What is fill factor and pad index?

1005

Can we join two tables without primary key?

1033

How to download and install the scaled-down database adventureworkslt?

981

How do use Having,Group by,Group function in SQL?

1727

what are the core components of SSRS?

127

Can a trigger be created on a view?

946

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1027

Explain logical operators in sql server?

1097

Explain the different index configurations a table can have?

929

What to check if a User database is locked?

1052

What Is Rdbms?

1143

What is ms sql server service broker?

975