76.

What is the difference between SET and SELECT methods?

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