-
set assigns only one variable at a time
if more than one match found, it errors out
set is ANSI standard
set assigns null if not match
-
select multiple variables can be assigned
if more than one found it picks the last value – incorrectly – need to check the logic
select is NON-ANSI standard
when no match it doesnt RESET the value to null but it retains its original value
0 Comments.