image_pdfimage_print
0

Difference between the SET and SELECT statements when assigning variables in T-SQL

see:{http://vyaskn.tripod.com/differences_between_set_and_select.htm see:{http://stackoverflow.com/questions/3945361/t-sql-set-versus-select-when-assigning-variables Quick Summary of Differences SET is the ANSI standard for variable assignment, SELECT is not. SET can only assign one variable at a time, SELECT can make multiple assignments at once. If assigning from a query, SET can… Continue Reading