<div>
@@rowcount = 0 means no rows were returned. &nbsp;In your case it may mean nothing was inserted or delete. &nbsp;How and where did you get this message?
</div>


@@rowcount = 0 means no rows were returned.  In your case it may mean nothing was inserted or delete.  How and where did you get this message?

<div>
<br />
I'm testing at the start of a trigger for @@rowcount. &nbsp;This is a trigger on insert/update/delete. <br />
<br />
So if I update a table and no transactions occur (Update Project set name = 'x' where 1=2), the trigger will still fire and @@rowcount will be 0?
</div>



I'm testing at the start of a trigger for @@rowcount.  This is a trigger on insert/update/delete.

So if I update a table and no transactions occur (Update Project set name = 'x' where 1=2), the trigger will still fire and @@rowcount will be 0?

<div>
<div class="content wysiwyg-content">
<br />
What does it mean when a trigger fire when @@rowcount = 0, and both the inserted and deleted tables are empty?<br />
<br />
Thx.<br />
<br />
jkavx
</div>
</div>



What does it mean when a trigger fire when @@rowcount = 0, and both the inserted and deleted tables are empty?

Thx.

jkavx

Trigger fires with inserted/deleted tables empty

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.