Difference between Set and Select

Question

Amit Singh · Answer

Difference between Set and Select Set is a ANSI standard for variable assignment. Select is a Non-ANSI standard when assigning variables. We can assign only one variable at a time We can assign multiple variable at a time When assigning from a query that returns more than one value, SET will fail with an error. When assigning from a query that returns more than one value, SELECT will assign the last value returned by the query and hide the fact that the query returned

interview

Difference between Set and Select

Can you answer this question?

1 Answers