Re: Can @@ROWCOUNT return NULL?
GeoSynch (SpamSlayed@xxxxxxxxxxxxxx) writes:
> Try removing
> SET NOCOUNT ON
> from the stored procedure.
@@rowcount should always return a value even if NOCOUNT is on. This
option controls whether rowcount information is passed to the client.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
.
Relevant Pages
- Re: Can @@ROWCOUNT return NULL?
... from the stored procedure. ... > Immediately after each statement I save the value returned by @@ROWCOUNT to ... it appears that in SQL Server ... This is not the case here - the only DML queries are INSERTs into ...
(comp.databases.ms-sqlserver) - Re: Hidden error kills my transaction. Help!
... Try SET NOCOUNT ON at the beginning of your stored procedure. ... SQL Server MVP ... > - the procedure is called from Delphi using ADO ...
(microsoft.public.sqlserver.programming) - Re: SQL 2000 Stored Procedure Problem
... I've got over 10 years with VB and SQL Server - ... spTestSimple: ... VB6/ADO to a SQL Stored Procedure when that Stored Procedure uses a Temp ... I added SET NOCOUNT ON as the first line in spTestTempTable - same ...
(microsoft.public.sqlserver.security) - Can @@ROWCOUNT return NULL?
... I am troubleshooting a relatively large stored procedure with ... Immediately after each statement I save the value returned by @@ROWCOUNT to ... Before doing any further troubleshooting, I would like to rule out the ... it appears that in SQL Server ...
(comp.databases.ms-sqlserver) - Re: multiple-step ole db operation generated errors? (Member of pr
... assign permissions to execute the stored procedure. ... I agree that the SET NOCOUNT ON wasn't the problem in this particular case. ... I've seen the DONE_IN_PROC messages prevent ADO apps from getting the SQL Server errors and is why I recommend it as a general practice for ADO applications. ...
(microsoft.public.sqlserver.security) |
|
