My New Article : A Closer Look Inside RAISERROR – SQLServer 2005

Today,  I have published another article on fundamental of RAISERROR in SQL Server 2005. Its all about  internal of RAISERROR, how to use it,  sp_addmessage, use them inside TRY-CATCH etc. If you really interesed, Here is my complete article

A Closer Look Inside RAISERROR – SQLServer 2005

My Articles, SQL Server 2005

Written by Abhijit Jana

Technology Leader, Technical Strategist, Solution Architect, Development Consultant, and a Trusted Technology Advisor with more than 13 years of experience in the IT industry with expertise in Development, Architecting, Engineering, Consulting, and Services Delivery. I am a former Microsoft MVP, Author of "Kinect for Windows SDK Programming Guide" and "HoloLens BluePrints" books, and founder of The Daily .NET Tips. To know more about me visit the "About Me" page.

1 comment

  1. Thank you good Article.

    I ‘ve a question.
    we can do this in Sqlserver2000 ?
    BEGIN TRY
    DECLARE @Intval int;
    SET @Intval = 1/0; — Devide by Zero Error
    END TRY
    BEGIN CATCH
    RAISERROR (50009, 11, 1); — 50009 is our pre-defined error that are stroed using sp_addmessage
    END CATCH;

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: