76.
What is the difference between SET and SELECT methods?
View Description
Assigning of values "," separated in SELECT like this is applicable
EX: SELECT @A = 1, @B = 2, @C = 3
following ex: is also true about SELECT
SELECT @A = 1
SELECT @B =2
SELECT @C = 3
Where as in SET, all variable assignments cannot be comma separated. only way of assigning values to multiple variables is by providing keyword SET before each assignment like this:
SET @A=1
SET @B=2
SET @C=3