Post reply

Query tables by datestamp?

  • February 12, 2007 at 12:09 pm

    #172031

    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]

  • February 12, 2007 at 1:27 pm

    #689286

    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.

  • February 12, 2007 at 1:56 pm

    #689294

    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

  • February 12, 2007 at 2:02 pm

    #689297

    Thats' what I was worried about.

    Darn developers. 

    [font="Verdana"]-- Wally
    -- Reluctant DBA[/font]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply