Post reply

By Pass Error While insetion

  • January 29, 2014 at 11:24 pm

    #396191

    Hi all,

    I have a scenario in which if I do bulk insertion in a table and if any error occurs then insertion should not stopped and will proceed with insertion of remaining records.

    Can we achieve this in sql?

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • January 30, 2014 at 2:06 pm

    #1684851

    Use the MAXERRORS option and set it to a really high number.

  • January 30, 2014 at 2:15 pm

    #1684854

    Adam Angelini (1/30/2014)

    Use the MAXERRORS option and set it to a really high number.

    And use an errorfile to find out what failed.

    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

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

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