Carlo Romagnano (8/17/2012)
Maybe, you miss the UPDATE clause:
declare @mykey int
update top 1 mytable set
@mykey = mykey
where status = 0
print @mykey
Hi, this is covered in the question itself: ...says "without using SET nor SELECT"
IgorMi
Igor Micev,My blog: www.igormicev.com