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

What are the approximate numeric data types?

Can we call SP inside a query?

How to a Query to copy data from on table to another table.

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

how to give input dynamically to a insert statement in sqlserver

What is the order by used for?

is there a column to which a default can't be bound? : Sql server database administration

how do we insert 100 records at a time in a table without using for loop in database

What are the dis_advantages of stored procedures, triggers, indexes?

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

What does set rowcount do?

Can two tables share the same primary key?

For more SQL Server Interview Questions Click Here