How to find the last update record in SQL Server?

Answer Posted / balaji.p

select ident_current(column) from table name

Is This Answer Correct ?    2 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the default Port No on which SQL Server listens?

621


What is updatable resultset?

513


What is the difference between the application object and session object?

597


Can we write ddl in trigger?

494


what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

512






Where to find ntwdblib.dll version 2000.80.194.0?

550


Do you know clustered and non-clustered index?

520


How do you create a clustered index?

521


How to define and use table alias names in ms sql server?

555


Can multiple columns be used in sql group by clause in ms sql server?

543


What is clustered vs nonclustered index?

505


What is a view and what are its advantages?

685


What is a full text index?

491


What is the difference between nvl and nvl2?

546


How do I find the port number for sql server?

500