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
List out the differences between the clustered index and non-clustered index in sql server?
What are the types of database schema? : sql server analysis services, ssas
how many layers of tcp/ip protocol combined of? : Sql server database administration
What are triggers in ms sql server?
What is advantage data architect?
Explain the relational database management system (rdbms)?
What is the difference between resultset and resultsetmetadata?
What is bookmark link in ssrs?
Explain the properties of the relational tables?
What is filter index?
How do I find query history in sql server?
Name 3 ways to get an accurate count of the number of records in a table?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What does it mean if @@cursor_row returns a negative number?
How can you tell if a database object is invalid?