[dba-SQLServer]SET vs SELECT

with Select you can assign values to multiple variables.  such as

SELECT @Column1 = T.Column1, @Column2 = T.Column2 From Table as T

In BOL it is recommended that the SET command be used instead, this 
maybe because you can use more attributes.

I think in SQL 2k, the Select command was able to be used to populate 
variables (i may be wrong about that).

Billy Pang wrote:

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



-- 
-Francisco