What is @@rowcount and with small code snippet explain the
usage?
- 4 Answers
- 13529 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / jagan
@@ROWCOUNT:
Returns the number of rows affected by the last statement.
ex:
UPDATE authors SET au_lname = 'Jones'
WHERE au_id = '999-888-7777'
IF @@ROWCOUNT = 0
print 'Warning: No rows were updated'
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What are the key events of sqlconnection class?
What is sql connection in ado.net?
Which object needs to be closed?
What are typed and untyped dataset?
List all the steps in order, to access a database through ado.net?
What is the advantage of ado.net?
Does sqlclient and oledb class share the same functionality?
What is sqldatareader?
What is disconnected architecture in ado.net?
Which namespaces are used for data access?
How to pass values into a datatable?
Which provider is used to connect ms access, oracle, etc…?
Can you explain how to enable and disable connection pooling?
What is ado control?
How do you update database through dataset?
