Select top 1 <Col-name> from <table> order by RecordTime desc

How to find the last update record in SQL Server?

Question Posted / ravindra

Answer Posted / ravindra

Select top 1 <Col-name> from <table> order by RecordTime
desc

Is This Answer Correct ?

17 Yes

18 No

Please Help Members By Posting Answers For Below Questions

Can we take the full database backup in log shipping?

993

Difference between report and query parameter.

1141

How to backup SQL Server Reporting Services ?

152

What command would you use to add a column to a table in sql server?

1354

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

983

What is the security principal at the database level that represents your session?

988

What is TDS(Tabular Data Stream) Gateway?

127

How to stop log file growing too big?

1059

Can we use custom code in ssrs?

1163

What methods do you follow to protect from sql injection attack?

1072

What is transaction server implicit?

1064

What is report server project?

155

What do you understand by replication in sql server? Mention the different types of replication in sql server.

990

What happens if you add a new index to large table?

979

What is a mutating table error and how can you get around it?

1124