want to copy data from one table to other table with the old table date timestump value


  • I am looking to insert a date time stamp every time I copy data from one table to another. This can be a trigger or stored procedure as long as I get the right insert time stamp.
    Tuesday, September 24, 2013 12:02 PM


  • add a column in table where you want to copy data with default value of getdate.

    so when every you insert data into table timestamp column took the insertion time automatically

    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

    Wednesday, September 25, 2013 2:08 PM