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
How do I know if localdb is running?
What do you mean by an execution plan?
How to create a user name in a database?
Are resultset updatable?
What is log cache in sql server?
What do you do in data exploration
What are the different types of triggers in SQL SERVER?
What is the purpose of data source?
how can you check the level of fragmentation on a table? : Sql server administration
Why do we need normalization?
What is rs.exe utility?
How we can refresh the view?
How many databases instances are there in sql server 2000?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What is meant by referential integrity?