Home Forums SQL Server 2008 T-SQL (SS2K8) Insert Multiple rows using Transacrtions RE: Insert Multiple rows using Transacrtions

  • June 29, 2013 at 3:49 am

    #1628481

    sankar.nandakumaran (6/28/2013)

    Hi..

    I have a table and need insert multiple data into it. First i have delete all data into the table and then insert multiple rows in table using sql transactions so that if any error comes all data will not be deleted.

    Thanks and Regards

    Sankar

    Cochin

    The quick answer for >SQL2008 would be something like:

    BEGIN TRAN

    [MERGE with INSERT. UPDATE, and DELETE]

    END TRAN

    Check out these articles:

    Using the MERGE Statement[/url]

    Merge error handling[/url]