Add a PRINT @@rowcount immediately after the SET statement. Bet a nickel that it is greater than 0.
If so, think about *why* and let us know if you can't figure it out from there.
Here's one more hint. Your answer is somewhere on this page:
http://technet.microsoft.com/en-us/library/ms187316.aspx
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills