How to find the date and time of last updated table?

Answer Posted / monal

USE TRIGGER OR ADD DATETIMESTAMP COLUMN IN A TABLE WITH
DEFAULT VALUE OF GETDATE()

Is This Answer Correct ?    9 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about thread and memory management process of SQL?

723


What are the properties of the transactions?

815


What is the distinction amongst delete and truncate?

739


What is ddl command?

703


How do you create an execution plan?

665






how to avoid cursors? : Sql server database administration

655


Explain the concept of recursive stored procedure.

666


What structure can you implement for the database to speed up table reads?

946


What are cursors stored procedures and triggers?

684


What is the chart in report?

125


What is collation?

880


What is log in sql server?

761


Which is the best place or learning center for MS SQL?????In Bangladesh?????

1759


Explain cross join or cartesian product in sql?

698


How to connect ms access to sql servers through odbc?

733