Home Forums SQL Server 2008 SQL Server 2008 Administration Insert into a table when new record RE: Insert into a table when new record

  • April 5, 2013 at 12:39 pm

    #1604082

    You could do it via trigger FOR INSERT or as part of the procedure used to insert the row using the OUTPUT clause.

    However, if you're just copying all the rows (with selected columns) into a new table, why do you need it at all? Couldn't you use a view or the same table?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2