1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How to find the last update record in SQL Server?

Question Posted / k.sridharan

Answers were Sorted based on User's Feedback



How to find the last update record in SQL Server?..

Answer / ravindra

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

Is This Answer Correct ?    17 Yes 18 No

How to find the last update record in SQL Server?..

Answer / sneha

uisng current .........

Is This Answer Correct ?    4 Yes 17 No

How to find the last update record in SQL Server?..

Answer / balaji.p

select ident_current(column) from table name

Is This Answer Correct ?    2 Yes 17 No

How to find the last update record in SQL Server?..

Answer / anil kumar

Select max(<columnname>) from <tablename>;

Is This Answer Correct ?    10 Yes 38 No

Post New Answer

More SQL Server Interview Questions

How do I edit a procedure in sql server?

0 Answers  

Can we call stored procedure in trigger?

0 Answers  

last function used in MS Access to convert sql what function will use in sql

0 Answers   Cap Gemini,

What is difference between after and before?

0 Answers  

What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,




What is the return type of executeupdate ()?

0 Answers  

What is amo? : sql server analysis services, ssas

0 Answers  

What can be used instead of trigger?

0 Answers   ADITI,

What is analysis service repository?

0 Answers  

What is the difference between stored procedure and user defined functions?

0 Answers  

What is create statement?

0 Answers  

What is normalization? Explain its different types?

0 Answers   GE, Maveric,

For more SQL Server Interview Questions Click Here
Categories