Post reply

SQL IF EXISTS Statement

  • October 7, 2010 at 9:40 am

    #224826

    I have written a Stored Procedure that contains the IF EXISTS Statement. I was wondering if I wanted to return a value or that tells me that THE IF EXITS part executed what would I need to add to my Stored Procedure? The primary reason I was needing to know this is because I am calling or executing this procedure within an application, ASP.Net to be more specific. And I just need some feedback from the stored procedure that a condition was true and the data was saved to the Database. Thanks for Any and All advice.

  • October 7, 2010 at 10:47 am

    #1233768

    You can add an output parameter to the stored procedure that returns a code or string to the calling app.

  • October 7, 2010 at 12:32 pm

    #1233859

    Thanks Sir.

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

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