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 |
harshilshah
Starting Member
8 Posts |
Posted - 2012-12-30 : 23:47:34
|
How do i get the no of rows effected from a delete querysomething like:row_affected= delete from weight where name="xyz"; |
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2012-12-30 : 23:55:49
|
Do you need this?Declare @row_affected intDelete from table_name where 1=2Set @row_affected=@@ROWCOUNT Select @row_affectedSenthil Kumar C------------------------------------------------------MCITP - Database Administration SQL SERVER 2008MCTS - Database Development SQL SERVER 2008 |
|
|
harshilshah
Starting Member
8 Posts |
Posted - 2012-12-31 : 00:05:03
|
@senthil: How do i get this working in C++ ?? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|