Home > Archive > MS SQL Server > March 2006 > Stored Procedure that deletes and informs of success?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Stored Procedure that deletes and informs of success?
D. Shane Fowlkes

2006-03-31, 8:23 pm

Hello all.

I have a SP (MS SQL 2000) that will delete select records from 3 unique
tables. The SP works fine but is there a way to return some kind of value
from the SP to know whether it worked or not? I'm using ASP.NET to call
the SP but I need to know whether or not the SP was successful or not. Make
sense? Thanks!


Andrew J. Kelly

2006-03-31, 8:23 pm

Use an output parameter that returns what values you need.

--
Andrew J. Kelly SQL MVP


"D. Shane Fowlkes" <shanefowlkes@h-o-t-m-a-i-l.com> wrote in message
news:eKtJ1rPVGHA.5496@TK2MSFTNGP11.phx.gbl...
> Hello all.
>
> I have a SP (MS SQL 2000) that will delete select records from 3 unique
> tables. The SP works fine but is there a way to return some kind of value
> from the SP to know whether it worked or not? I'm using ASP.NET to call
> the SP but I need to know whether or not the SP was successful or not.
> Make sense? Thanks!
>
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com