How to genrate automaticlly empid like gt001

Answer Posted / pravati

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about link server in sql server?

529


What information is maintained within the msdb database?

534


How many primary keys are possible in a table?

513


Can you explain about buffer cash and log cache in sql server?

492


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1322






What is database black box testing?

601


What do you understand by a view? What does the with check option clause for a view do?

601


What is the use of @@spid?

565


What is a primary key?

534


What is the library index called?

580


What is for xml in sql server?

531


Can a synonym name of a table be used instead of a table name in a select statement?

570


Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

573


What are the three different part of rdl file explain them?

168


What is the command to change the recovery model?

565