Answer Posted / chandramohan
scope_identity() would be the currect answer. To avoid potential problems professionals suggests this method since it returns the recently added value.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are xml indexes?
Explain timestamp datatype?
Can we do dml on views?
Explain Capacity planning to create a database? and how to monitor it?
what are constraints? : Sql server database administration
Tell me can we use custom code in ssrs?
How to list all user defined functions in the current database?
What are the general features of sql server management studio? : sql server management studio
Which are new data types introduced in sql server 2008?
How do you make a trace?
explain how to create a new schema in a database? : Sql server database administration
What is the difference between stored procedure and functions?
What is the difference between varchar and varchar(max) datatypes?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
Explain aggregate functions?