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

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?..

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?..

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

Is This Answer Correct ?

5 Yes

1 No

More SQL Server Interview Questions

Difference between Inner vs outer joins?

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

What are cursors and when they are useful?

How to throw custom exception in Stored Procedure?

how to find number of columns in a table in sql server 2000 and 2005 also

What is compression - row-level and page-level compression?

How to update values in a table with update statements in ms sql server?

Can you explain the disadvantages/limitation of the cursor?

How can you insert values in multiple rows using one Insert statement?

Anyone please explain me the concept of Serialization?

What are mdf,ndf,ldf files and how to see the data in those files?

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

For more SQL Server Interview Questions Click Here