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

2 Answers
8851 Views
I also Faced
E-Mail Answers

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

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

0 Answers

How to retrieve data from log files in SQL SERVER ?????

1 Answers

How do I view a stored procedure in sql server?

0 Answers

what is lazy writer?

1 Answers Wipro,

What is dbcc command in sql server?

0 Answers

What is the difference between row_number and dense_rank?

0 Answers

What is the syntax to execute the sys.dm_db_missing_index_details?

0 Answers

What are the recovery models in sql server 2000?

0 Answers

Do you know what is difference between stored procedure and user defined function?

0 Answers

What are Magic Table?

34 Answers 3i Infotech, Digiweb, Evalueserve, NIIT, PL,

What is 3nf normalization form?

0 Answers

For more SQL Server Interview Questions Click Here