Post reply

ecxptions

  • May 2, 2010 at 4:24 am

    #224087

    how to do exception in sql server 2005

  • May 2, 2010 at 5:31 am

    #1160975

    take a look in books on line for the try-catch statement;

    if an error is raised, you can put in some logic to do something different that failed in the TRY

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 3, 2010 at 2:57 am

    #1161145

    pradeepmsbi (5/2/2010)

    how to do exception in sql server 2005

    SET ANSI_WARNINGS ON;

    PRINT 1/0;

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • May 3, 2010 at 7:07 am

    #1161235

    Here's an article just on how to handle errors within TSQL code:

    http://www.simple-talk.com/sql/t-sql-programming/sql-server-error-handling-workbench/[/url]

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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