Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 SET or SELECT

Author  Topic 

cornall
Posting Yak Master

148 Posts

Posted - 2007-05-25 : 05:55:29
What is the difference between these :-

SET @var1 = 'hello'
SELECT @var1 = 'hello'

when shoudl they be used?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-05-25 : 06:03:50
see

http://vyaskn.tripod.com/differences_between_set_and_select.htm
http://weblogs.sqlteam.com/brettk/archive/2007/02/12/60090.aspx
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79005
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55620



KH

Go to Top of Page

cornall
Posting Yak Master

148 Posts

Posted - 2007-05-25 : 06:39:18
Thanks should have done a search! Cheers for the answer.

D
Go to Top of Page
   

- Advertisement -