Comments on Sql Server Blog: SET VS SELECT - When to use what?

Thanks Boyan and Bart for the informative comments...

2008-04-27T11:02:09.055-07:00

Thanks Boyan and Bart for the informative comments..

Multiple assignments is by far the biggest reason ...

2008-04-27T08:58:52.927-07:00

Multiple assignments is by far the biggest reason to use select over set. It gives you a huge performance gain if you are setting a lot of variables for a big sproc/script

declare @test int, @test2 int;
set @test = 1, @test2 = 2; --doesn't work
select @test = 1, @test2 = 2; -- works

A shorter variation of:SELECT @CID = (Select CID f...

2008-04-25T05:49:45.221-07:00

A shorter variation of:
SELECT @CID = (Select CID from Customers)
is
SELECT @CID = CID from Customers