Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
svallamreddy
Starting Member
4 Posts |
 Posted - 2007-06-12 : 05:56:15
|
| Hi,In a procedure I want to know the no. of rows effected.That means. No of rows inserted, updated , and no of records retrieved by an SQl statement.Is there any way to know.ThanksSreenu |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-06-12 : 06:02:45
|
use select @@rowcount after your query
KH |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-06-12 : 08:42:57
|
quote:
Originally posted by khtan
use select @@rowcount immediately after your query
KH
MadhivananFailing to plan is Planning to fail |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-12 : 11:31:36
|
quote:
Originally posted by madhivanan
quote:
Originally posted by khtan
use select @@rowcount immediately after your query
KH
MadhivananFailing to plan is Planning to fail
Madhithats a bad way to increase your post count It may be legal but its not fair..  Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-06-12 : 11:35:30
|
quote:
Originally posted by dinakar
quote:
Originally posted by madhivanan
quote:
Originally posted by khtan
use select @@rowcount immediately after your query
KH
MadhivananFailing to plan is Planning to fail
Madhithats a bad way to increase your post count It may be legal but its not fair.. Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/
In fact there is difference between after and immediately after  MadhivananFailing to plan is Planning to fail |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-12 : 11:41:25
|
| yeah ...yeah....Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
No. of Rows effected