Sql Result Set Into Variable. The data can be formatted as an array or an object. Create procedure addFaculty ID int OUTPUT as begin IF NOT EXISTS Select AccountType from UserTable where AccountType Faculty begin Insert into CredentialsTable values iamafaculty.
Replace the text NewResultName in the Result Name column with the ordinal 0. The other day during Comprehensive Database Performance Health Check I was asked if there is a way to store results of dynamic SQL into a variable. Create procedure addFaculty ID int OUTPUT as begin IF NOT EXISTS Select AccountType from UserTable where AccountType Faculty begin Insert into CredentialsTable values iamafaculty.
The query returns one row.
If the query returns zero rows then the variable is set to EMPTY ie NULL. Getting result of dynamic SQL into a variable for sql-server. If you are looking to set the ID variable parameter you need to specify it as an OUTPUT parameter and set its value in your query. This is a very popular question and let us see the answer to this question in this blog post.