[dba-SQLServer]SET vs SELECT

AFAIK, no difference....
I usually use SET when assigning a single value and SELECT to set values 
obtained from a table.




>From: David Emerson <davide at dalyn.co.nz>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: dba-SQLServer at databaseadvisors.com
>Subject: [dba-SQLServer]SET vs SELECT
>Date: Wed, 08 Oct 2003 17:00:43 +1300
>
>I have seen these commands used in similar situations.  Eg
>
>SET @myVar = 10
>SELECT @myVar = 10
>
>Are they interchangeable or do they have different purposes?
>
>Regards
>
>David Emerson
>DALYN Software Ltd
>25b Cunliffe St, Johnsonville
>Wellington, New Zealand
>Ph/Fax (877) 456-1205
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail