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


Please Help Members By Posting Answers For Below Questions

What are the different ways you can create databases in sql server?

579


If you want to send some data from access database to sql server database. What are different component of ssis will you use?

515


Can we use max in where clause?

529


What are different types of views?

561


How to execute stored procedure in select statement sql server?

543






How optimize sql query with multiple joins in sql server?

423


Explain how many types of relationship?

585


How to provide default values to function parameters?

609


What is the difference between DATETIME2 and DATETIME?

644


between cast and convert which function would you prefer and why?

553


What are various ways to enhance the ssrs report?

544


What is the cartesian product of the table?

558


Where is my database stored on the hard disk in ms sql server?

602


how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

470


What is data modification?

519