User Id :    Password :      New Member   Forgot Password  
Topic: How to know that how many rows are affected in sql server 2005?
Anamika singh
23 Nov 2010 at 02:37 AM
How to know that how many rows are affected in sql server 2005?
Re: How to know that how many rows are affected in sql server 2005?
Gaurav
16 Dec 2010 at 03:00 AM
The @@Rowcount function will be set after any statement that changes or returns rows. In the following statement, the RowsReturned column will display the number of rows selected by the previous select statement:
SELECT * FROM AUTHORS
WHERE state = 'CA'
SELECT @@rowcount AS 'RowsReturned'

Total Replies: 1
 
Featured Text Ad

Featured Ad