Posted by Jason Lepack on 07/26/07 19:17

http://ryanfarley.com/blog/archive/2004/03/01/390.aspx

On Jul 26, 1: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

[Back to original message]