Posted by MikeJ on 07/26/07 17:59

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

• Next in forum: Deleting all data
• Prev in forum: Training/Certification Recommendation for experinced DBA
• Thread view: general question

[Reply to this message]