Records affected

[Guest]

I was using a SP to Update records and I was geting the records affected via

Num = myCommand.ExecuteNonQuery()

after I introduced an Output parameter inside the SP, I can see no more the
records affected by the Update, should I add something to the SP?

--

 

[Guest]

1. You are executing with no query (output)
2. You added an output parameter.

While it is still running as "execute non query" in your .NET code, you have
introduced a query, which means it really is no longer a "non query"
execution. I would consider adding another output parameter to get the number
of rows affected.


---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

 

[David Sceppa]

Kenny,

Could you post a simple stored procedure that reproduces this problem?
Thanks.

David Sceppa
Microsoft
This posting is provided "AS IS" with no warranties,
and confers no rights. You assume all risk for your use.
© 2005 Microsoft Corporation. All rights reserved.