Home Forums SQL Server 7,2000 T-SQL @@rowcount Returns 0 RE: @@rowcount Returns 0
David Webb-CDS
SSCoach
Points: 17398
More actions
February 6, 2007 at 5:11 pm
#688171
Just a guess. @@rowcount is returning the rowcount from the current context (in this case, the trigger).
How about using
IF (select count(*) from INSERTED) = 0
instead?