I am needing a way to run an
If/Else statement in SQL Server. This is what I am needing done, if my
Exec sp_executesql @SQL statement returns a value (meaning it exists in the table) I want to set the value returned to a variable. If it does not return a value, then I want to print a message saying it does not exist.
With the sample DDL Below, I would want to assign the value of 3 to the variable
@placeholder since 3 would be the value returned. How would that syntax be constructed?
Create Table #Test1 (id int,name varchar(100)) Insert Into #Test1 Values (1, 'Blue'), (2, 'Red'), (3, 'Pink'), (4, 'Orange') Declare @Color varchar(100), @sql nvarchar(max), @placeholder varchar(100) Set @Color = 'Pink' Set @Sql = 'Select id from #Test1 WHERE name IN ('''+@Color+N''')' Exec sp_executesql @SQL Drop Table #Test1