select @@error'Error' select @@rowcount'Rows'

How do you find the error, how can you know the number of
rows effected by last SQL statement?

Question Posted / chandra rekha

Answer Posted / chandra rekha

select @@error'Error'
select @@rowcount'Rows'

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to delete existing rows in a table?

1137

Where are full-text indexes stored?

976

What is the difference between online clustering and Offline clustering?

2393

What is difference in performance between insert top (n) into table and using top with insert?

1019

Can you move the resources after pausing the node? : sql server database administration

1077

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

109

How can you list all the table constraints in a database?

920

Explain database normalization?

1200

What are system databases into sql server (2005/2008) : sql server database administration

996

Why de-normalization required?

985

What is 3nf normalization?

975

Explain forward - only cursors?

1039

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1022

What authentication modes does sql server support?

1071

How to get the number of affected rows?

989