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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-08 : 07:56:42
|
| kishore writes "In the stored procedure, i am updating some records(in the middle of the procedure),After updating i want to know how many records are updated. Based on this condition my procedure will continue." |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-06-08 : 08:25:17
|
| look at @@rowcount |
 |
|
|
srinivasanr
Starting Member
15 Posts |
Posted - 2004-06-08 : 08:27:31
|
| Hi,Use SET NOCOUNT OFFand get @@ROWCOUNT to a variableWallops !! |
|
|
|
|
|
|
Stored procedure