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 is normalization and what are the advantages of it?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What is a schema in ms sql server 2005?
What is the process of indexing?
What are scheduled tasks in sql server?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Do you know what is sql service broker?
What are scalar functions?
Mention the differences between substr and charindex in sql server.
How many clustered indexes there can be on table ?
Why I can not enter 0.001 second in date and time literals in ms sql server?
what is the difference between openrowset and openquery?
Where are full-text indexes stored?
Explain the relational database management system (rdbms)?
Explain the xml support sql server extends?