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

Is it important for a database administrator to understand the operating system and file access?

0 Answers

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

0 Answers

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers

What are the components of dbms?

0 Answers

What is normalization and what are the advantages of it?

0 Answers

What are tables in sql server?

0 Answers

How to truncate the log in sql server 2012? : sql server database administration

0 Answers

Explain the types of indexes.

0 Answers Accenture,

Write a SQL queries on Self Join and Inner Join.