Carlo Romagnano (11/25/2009)

---

WARN: If you use an aggregate function @a will be updated also if no row is returned

[font="Arial"]SET NOCOUNT ON

declare @vals table (iKey int, iValue int)

insert into @vals (iKey, iValue)

select 1,1

union select 2,2

union select 3,3

declare @a int

set @a = 5

select @a = iValue from @vals where iKey = iValue order by iKey

select @a

select @a = iValue from @vals where iKey <> iValue

select @a

select @a = COUNT(*) from @vals where iKey <> iValue

select @a[/font]