[dba-SQLServer]SET vs SELECT

Billy Pang tuxedo_man at hotmail.com
Wed Oct 8 00:23:59 CDT 2003

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?
>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

Add photos to your e-mail with MSN 8. Get 2 months FREE*.  

More information about the dba-SQLServer mailing list