Difference between SET & SELECT in TSQL
The following Two blogs explains difference between SET & SELECT When assigning values to local variables. http://vyaskn.tripod.com/differences_between_set_and_select.htm http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/05/18/449.aspx