@@ROWCOUNT: Returns the number of rows affected by the last statement.

What is @@rowcount and with small code snippet explain the
usage?

Question Posted / jagan

4 Answers
14712 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 ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is executequery?

962

Explain the differences between oledb sql server, oledbdotnet provider?

1021

What is the difference between OLEDB Provider and SqlClient?

996

Explain why canot we use multiple inheritance and garbage collector paralelly in .net?

1032

How to find the given query is optimised one or not?

984

What is connection in ado.net?

960

How is it possible to get 2 tables of data at a time by using data reader?

964

What are three methods for displaying data in a syncfusion datagrid

1086

Explain the advantages and disadvantages of using datalist?

1080

What is the difference between DataReader and DataSet in ADO.NET?

1177

What is fill method in ado.net?

992

oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

2399

What is the full form of ado.net?

998

What is data access pattern?

957

Explain the difference between sqlcommand object and command behavior object?

1099