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 different ways you can create databases in sql server?

What do you mean by stored techniques? How would we use it?

Can group functions be used in the order by clause in ms sql server?

Explain the steps to create and execute a user-defined function in the sql server?

When we should use @@error?

to explain sql server 2000 architecture & authentication

What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

Can another user execute your local temporary stored procedures?

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

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

Explain about nested stored procedure?

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

For more SQL Server Interview Questions Click Here