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
8959 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

how to dispaly a particular row details from a given table

2 Answers

How to write character string constants or literals in ms sql server?

0 Answers

What is the Disadvantage of indexed sequential file.

0 Answers HCL,

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers 3i Infotech, Rolta, TCS,

What happens if null values are involved in comparison operations?

0 Answers

How to add an address record into adventureworkslt?

0 Answers

What do you mean by data integrity?

0 Answers

Explain tablesample?

0 Answers

What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?

7 Answers

What is an expression in ms sql server?

0 Answers

Give a example to search fr a string in all stored procedure in sql server.

0 Answers

How do you create an execution plan?

0 Answers

For more SQL Server Interview Questions Click Here