I have found some documentation regarding the use of IF...ELSE statements in stored procedures, but what about multiple condition statements? For example, say I need 3 unique fields in my table. If my application passes a value that is a duplicate in one of the columns, the stored proc will fail, but it is difficult to know which item caused the failure and therefore difficult for the user to get a meaningful error message in order to correct their input. I am thinking I could just make a conditional statement that applies a code to an OUTPUT parameter in order to clarify the error:
(pseudo code)
if @.field1 already exists then @.output = '1';terminate stored procedure
elseif @.field2 already exists then @.output = '2';terminate stored procedure
elseif @.field3 already exists then @.output = '3';terminate stored procedure
else finish the insert
(end pseudo code)
Are 'elseif' statements allowed in SQL Server? Am I going about this in the wrong way?
Jungalist wrote:
Are 'elseif' statements allowed in SQL Server?
Sort of. You can impletemt the logic as follows :
IF @.field1 already exists
BEGIN
SET @.OUTPUT = 1
END
ELSE
IF @.field2 already exists
BEGIN
SET @.OUTPUT=2
END
ELSE
IF @.field3 already exists
BEGIN
SET @.OUTPUT=3
END
check out books on line for "IF ELSE"
|||
Thank-you. I was searching for the wrong terms. I appreciate the help.
