HomeSQL SERVER INTERVIEW QUESTIONSHow to get the list of tables changed with in the database in last 5 days? Write SQL Query, Interview Question How to get the list of tables changed with in the database in last 5 days? Write SQL Query, Interview Question 1 Vikas 20:13 SELECT name, create_date, modify_date FROM sys.objects WHERE modify_date >= GETDATE()-5 and type ='U' (this query will list out all table which have been modified(make changes) within last 5 days) Tags SQL INTERVIEW SQL INTERVIEW QUERY SQL SERVER SQL SERVER INTERVIEW QUESTIONS Newer Older
good
ReplyDelete