INSERT INTO TABLE NAME(EMPLOY ID) VALUES('gt

How to genrate automaticlly empid like gt001

Question Posted / pravati

Answer Posted / pravati

INSERT INTO TABLE NAME(EMPLOY ID) VALUES('gt_001')

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Define tempdb database?

1007

Can we add an identity column to decimal datatype?

1007

How you can get the list of largest tables in a database?

1024

Differentiate between a local and a global temporary table?

965

How to perform backup for certificates in sql server? : sql server security

1103

What is the use of set nocount on/off statement?

1102

Ms sql server index?

1070

What are the functions in sql server?

958

What is indexing a document?

1040

What are data driven subscriptions?

115

ow to bring suspect mode datbase online from scratch

1815

Explain how many types of relationship?

1041

What are data resources?

924

What do we have to check in database testing?

1027

what are database files and filegroups? : Sql server database administration

953