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

What is the maximum length of an alert name?

1001

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1042

What are constraints?

1010

What methods do you follow to protect from sql injection attack?

1029

How do you create a clustered index?

1056

What is a mutating table error and how can you get around it?

1050

How can I check if a view exists in a sql server database?

1038

What is Command line parameters in PLSQL.?

1128

What is an sql server agent?

1063

How to store and query spatial data?

993

What is tablix?

162

What is @@error in sql?

1064

explain what is raid and what are different types of raid configurations? : Sql server database administration

1002

Describe in brief databases and sql server databases architecture.

1009

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

1110