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

How can we remove orphan records from a table?

981

How to disable a login name in ms sql server?

1132

How to execute a stored procedure in ms sql server?

1170

Can an entity have two primary keys?

979

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3873

How to resolve the orphan use problem? : sql server security

1014

What is SQL Azure Federations?

112

What is instead of trigger sql server?

999

What are the steps to follow to configure SQL*Net?

1035

How does normalization work?

916

What do you mean by sql server 2005 express management tools?

1300

What is default constraint in ms sql server?

1033

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1030

How to encrypt Strored Procedure in SQL SERVER?

1167

How do I make a resultset scrollable?

958