How to find the latest updated value in a table without
sending any parameters to that query
Answer Posted / honey
by using scope_identity()
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the new features of sql server 2012 reporting service?
Can a database be shrunk to 0 bytes, if not, why?
What are the key configuration files for sql server reporting services ?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What is difference between equi join and inner join?
How does Report Builder support Analysis Services cubes?
how can a database be repaired? : Sql server administration
What are the source of constraints?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is conditional split?
Explain what are sparse columns?
Explain the properties of a relational table?
what information is maintained within the msdb database? : Sql server administration
Explain about sql server login?