Query tables by datestamp?
-
Hi All,
I have several tables I want to archive by date, the table creators never implemented a date column.
How do I query via a built-in SQL Server datestamp?
Thanks!
[font="Verdana"]-- Wally
-- Reluctant DBA[/font] -
Can't say I have seen an internal datastamp against a row. Maybe there is something in DBCC PAGE but this would be an absolute nightmare to extract...if possible at all.
-
What do you mean by "a built-in SQL Server datestamp"? Do you really think that Microsoft hid code that puts a date/time stamp on every row of data?
SQL Server doesn't care when you put data into a table, or change it, or delete it. It's up to you to track that by creating date/time columns or some other method.
-SQLBill
-
Thats' what I was worried about.
Darn developers.
[font="Verdana"]-- Wally
-- Reluctant DBA[/font]
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply