Hello everyone!
Just now, I have read this
Article[
^] and have a doubt how to use
@@ROWCOUNT
to get affected number of rows keeping
NOCOUNT ON
.
I have tagged this in ASP.Net(C#) as I am using it as the front end and need some guidance whether I can do this or not.
I want to know the number of rows affected by the stored procedures and accordingly execute the codes. So, is there any way to know the number of rows affected by a stored procedure even after keeping
NOCOUNT ON
?
If yes, then which one?
Please help..