Posted by MikeJ on 08/06/07 19:02

thanks alot for you responses
MJ

"Alex Kuznetsov" <AK_TIREDOFSPAM@hotmail.COM> wrote in message
news:1186015563.112873.176440@j4g2000prf.googlegroups.com...
> On Jul 26, 12:59 pm, "MikeJ" <vettes_n_j...@sbcglobal.net> wrote:
>> hi...i would like to know best practice when assigning a value to a
>> variable
>> example below
>>
>> set
>> or
>> select
>>
>> declare @var1 varchar(25)
>> set @var1='abc'
>> select @var1='abc'
>>
>> to me
>> set is implicit
>> select implies conditions
>>
>> i see both used all over the place here at my new company....
>> so witch is better practice
>>
>> tks
>> MJ
>
> Mike,
>
> If you need to do many assignments at once, a single assignment
>
> SELECT @var1 = @value1,
> (snip)
> @var9 = @value9
>
> may run faster than
>
> SET @var1 = @value1
> (snip)
> SET @var9 = @value9
>
> Verify that. I did benchmarks on 2000 and noticed a difference, but
> did not repeat on 2005.
>
> Alex Kuznetsov, SQL Server MVP
> http://sqlserver-tips.blogspot.com/
>

[Back to original message]