1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



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

Answer / chandra rekha

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

Is This Answer Correct ?    4 Yes 0 No

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

Answer / laxman

select @er=@@error,@rc=@@rowcount

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is instead of trigger sql server?

0 Answers  

What is a document index?

0 Answers  

Explain system views?

0 Answers  

Does sql server 2000 full-text search support clustering?

0 Answers  

What is a join and their types?

2 Answers   Challenger Financial,




How to find the version of sql server? : sql server database administration

0 Answers  

optimization techinques

0 Answers   Wipro,

What are the differences between decimal and float in ms sql server?

0 Answers  

Explain trigger classes i.e. Instead of and after trigger?

0 Answers  

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

0 Answers  

How to drop existing views from a database in ms sql server?

0 Answers  

Security Question- SQL DBA exparts, need your help...

3 Answers  

For more SQL Server Interview Questions Click Here
Categories