My learning and thoughts
Original Link
DECLARE @n_days INTDECLARE @n_days INTSET @n_days = 10 --Give the number of daysSELECT[name],create_date,modify_dateFROMsys.tablesWHERE modify_date > GETDATE() - @n_daysAND schema_id = 5ORDER BY modify_date DESC
Post a Comment
No comments:
Post a Comment