what is difference between SET and SELECT in SQL Server
what is difference between select and set statements while assigning a value to a variable? Which one should be used when?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Khargesh RajputPosted Apr 2, 2015, 12:21 AM
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
Vineet KumarPosted Apr 2, 2015, 12:12 AM
Khargesh RajputPosted Apr 2, 2015, 12:09 AM
and select is used to return the value