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

What is GUID in sql server?

738


What are the built in functions in sql server?

574


What is the recovery model? List the types of recovery model available in sql server?

558


How would you use user_constraints table in DB?

675


Can we install sql server 2016 on windows 7?

767






hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1872


What are the properties of primary key?

618


Difference between report and query parameter.

695


Explain what are the different index configurations a table can have?

773


How can you manage sql azure security?

95


What is cached report?

112


How to write character string constants or literals in ms sql server?

637


How do I run a trace in sql server?

592


Tell me what is the difference between locking and multi-versioning?

667


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1809