Difference between using SET and SELECT when assigning variables in T-SQL
I came across a great article by Narayana Vyas Kondreddi that describes the difference between the SET and SELECT .The article is well worth the read, but here are the main points: SET is the ANSI standard for variable assignment, SELECT is not.SET can only assign one variable at a time, SELECT can make multiple […]