Does Your SP Choke on Errors

  • sunjiulu:

    When I execute spStaticNoStopOnFirstError in the pubs database on SQL Server 2000. Both statements in the SP execute even though the first query fails because of a constraint on the table. The second query will succeed the first time it is run. After that it will fail unless you delete all the rows it inserted. In any case, for me both queries run every time I execute this SP.

    Are you getting a different reaction when you execute this SP?

    Robert W. Marda

    SQL Programmer

    bigdough.com

    The world’s leading capital markets contact database and software platform.

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • Nice, clean, concise examples.  Thank you


    Regards,

    Mike

Viewing 2 posts - 16 through 16 (of 16 total)

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