Sign Up Login


  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

how do u find least salary in a table

4 Answers  

What is scheduled job and how to create it?

0 Answers  

Difference between LEN() and DATALENGTH() in sql server ?

0 Answers   HCL,

How to update muliple row in single query?

0 Answers   MCN Solutions,

Relational calculus is what type of language?

0 Answers   HCL,




How many full-text indexes can a table have?

0 Answers  

What is 1nf 2nf and 3nf?

0 Answers  

between cast and convert which function would you prefer and why?

0 Answers  

How to change the system date and time from SQL Plus Terminal ?

0 Answers   MCN Solutions,

What are the authentication modes in sql server? How can it be changed?

0 Answers  

What are “lost updates”?

0 Answers  

How do you test your database? : sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories