getting insertion time of row in SqlServer RRS feed

  • Question

  • How can we get insertion time of row in SqlServer?(without adding any column in table)
    is any where System maintains Time Of insertion?
    Wednesday, November 21, 2007 5:56 AM



    No, Sql Server itself does not maintain the time of insertion. You can, of course, add an additional column for that purpose and set its default value to getdate(). If you wish, you can "fake" a table that does not have that column by means of a View that selects all columns except for the one that you added for the insertion time.


    Wednesday, November 21, 2007 8:46 AM