How to return a single string value from a Stored procedure without using the Output parameters in the SP.
Is this possible ?
The single string value returned by the SP would contain the Sucess or failure message with reason for the failure as well.
How can do this ?
Something like this at the end of the sp:
IF (SomeCondtion)
BEGIN
SELECT 'Success'
END
ELSE
BEGIN
SELECT 'No success'
END
In this link you can find other methods that suit your needs http://www.sqlteam.com/article/stored-procedures-returning-data
OUT
variable - Leigh 2012-04-06 05:15
SELECT 'Success, it worked'
right at the end - ta.speot.is 2012-04-05 21:59