Re: Can @@ROWCOUNT return NULL?
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Mon, 29 Aug 2005 21:14:27 +0000 (UTC)
Dimitri Furman (dfurman@xxxxxxxxxxx) writes:
> Is it possible for the @@ROWCOUNT function to return NULL after a
> statement? I am troubleshooting a relatively large stored procedure with
> multiple SELECT statements and a couple of INSERTs into table variables.
> Immediately after each statement I save the value returned by @@ROWCOUNT
> to a local variable. That information eventually is passed back to the
> client via one output parameter, for all statements in the procedure.
> Occasionally, the value returned via that parameter is NULL. This cannot
> be reproduced by re-running the SP with the same input parameters.
>
> Before doing any further troubleshooting, I would like to rule out the
> possibility that @@ROWCOUNT can actually return a NULL under some
> circumstances. From searching the archives, it appears that in SQL
> Server 7.0 this could happen in the context of a DML query on a table
> with triggers. This is not the case here - the only DML queries are
> INSERTs into table variables, all other queries in the SP are SELECTs.
I have never heard of a case where @@rowcount can return NULL. Books
Online gives one hint when @@rowcount is not good: when more than two
milliard rows can be affected. In this case, you should try
rowcount_big(). Could this apply to you?
If not, I would recommend that you start troubleshooting. If it is not
repeatable, it will certainly be difficult...
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
.
- References:
- Can @@ROWCOUNT return NULL?
- From: Dimitri Furman
- Can @@ROWCOUNT return NULL?
- Prev by Date: Re: What does schema mean?
- Next by Date: Re: Backup User - Server Role?
- Previous by thread: Can @@ROWCOUNT return NULL?
- Next by thread: Re: Can @@ROWCOUNT return NULL?
- Index(es):
Relevant Pages
|
