what is difference between SET and SELECT in SQL Server

Question

what is difference between select and set statements while assigning a value to a variable? Which one should be used when?

Vineet Kumar · Answer

Please read question carefully. Value can be assigned using select or set statement. What Diff does it make?? That's the question.

Khargesh Rajput · Answer

sorry i have focused on title only below link have answer http://www.mssqltips.com/sqlservertip/1888/when-to-use-set-vs-select-when-assigning-values-to-variables-in-sql-server/ http://vyaskn.tripod.com/differences_between_set_and_select.htm

Khargesh Rajput · Answer

set is used to assign any value and select is used to return the value