I want to run through two IF statements in sql. The IF's are two different conditions, example:
IF (@user == 'Bob')
BEGIN
SELECT * FROM table Where id = 1
END
IF (@animal == 'Cat')
BEGIN
SELECT * FROM table WHERE id = 50
END
What i want back are rows 1 if only the first condition is correct or 1 and 50 if both conditions are met.
This fails at the second IF statement, is there another keyword I need to add?
I recommend a single statement:
SELECT
*
FROM table
WHERE
(@user = 'Bob' AND Id = 1)
OR
(@animal= 'Cat' AND Id = 50)
user = 'Bob' AND Animal = 'Cat' and ID to 1 if User = 'Bob'. This query does not do that. Based on his question i would suggest ELSE IF instead of two IF's.
IF (@user == 'Bob')
BEGIN
SELECT * FROM table Where id = 1
END
ELSE IF (@animal == 'Cat') and (@user == 'Bob')
BEGIN
SELECT * FROM table WHERE id = 50
END
IF (@user = 'Bob')
BEGIN
IF (@animal = 'Cat')
BEGIN
SELECT * FROM table WHERE id = 50
END
ELSE
BEGIN
SELECT * FROM table Where id = 1
END
END
I think this might work for what you want.
SELECT * FROM table Where id = 1 && @user == 'Bob'
Union
SELECT * FROM table WHERE id = 50 && @animal == 'Cat' && @user == 'Bob'
Try this nested if function:
SELECT * FROM table Where id = IF(@user=='Bob',1,IF(@animal=='Cat',50));
