Finding Rows Affected By T-Sql Update,Delete,Select, Insert
To find out how many records are affected after the execution of any SQL statement
you can simply use the built in SQL Server property @@ROWCOUNT
select * from your_table
print @@ROWCOUNT
|The Output should look like this:
(8 row(s) affected)
8
you can simply use the built in SQL Server property @@ROWCOUNT
select * from your_table
print @@ROWCOUNT
|The Output should look like this:
(8 row(s) affected)
8
Comments
Write the first comment
Leave a trace
Post being viewed right now
Item date: 24.08.2009
Views: 990
Views: 990
