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

Explain few examples of stored procedure over triggers?

1114

What is open database communication (odbc)?

1115

What are diverse clauses that form a part of sql?

1110

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

990

What are truncate options available in sql server? : sql server database administration

1083

What is the use of keyword with encryption.

1081

Is it possible to update the views? If yes, how, if not, why?

1082

List down some advantages of sql stored procedure?

1015

How do I find the sql server version?

1080

what is bit datatype? : Sql server database administration

963

Write SQL queries on Self Join and Inner Join.

1215

What stored procedure would you use to view lock information?

1017

Give an example of why you would want to denormalize a database

1029

How to insert multiple rows with a subquery?

1187

What factors you will consider calculating the storage requirement for that view?

990