CODEWITHSUNDEEP
sql-server-2005t-sqlasp.net-3.5raiserror
Curtis
Curtis

Reputation: 103358

T-SQL - Return custom error message and end query

I have a lengthy stored procedure in which I would like to do something like the following:

IF @SubPageDirectory IS NULL
BEGIN
    RAISERROR('@SubPageDirectory cannot be NULL', 10, 1)
    EXIT STORED PROCEDURE
END

Basically I wish to check whether my variable is NULL, and if it is, return an error message to my .NET Web Application, and stop running the query at that stage. How can I achieve this?

Upvotes: 9

Views: 22500

Answers (1)

gbn
gbn

Reputation: 432261

IF @SubPageDirectory IS NULL 
BEGIN 
    RAISERROR('@SubPageDirectory cannot be NULL', 16, 1) --change to > 10
    RETURN --exit now
END

Upvotes: 18

Related Questions