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 / kaumil2001

1 Answers
4593 Views
I also Faced
E-Mail Answers

How do you find the error, how can you know the number of rows effected by last SQL statement?..

Answer / laxman

select @@error
select @@rowcount

Is This Answer Correct ?

10 Yes

0 No

Post New Answer

More SQL Server Interview Questions

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers Microsoft,

How to execute multiple stored procedures at one time in sql server?

0 Answers

List some major differences between triggers and stored procedures?

0 Answers

what is difference between primary key and Unique

8 Answers

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers United Healthcare,

If we shrink the Databse and Files, how much size is decreased?

1 Answers TCS,

How many types of TRIGGERS are there in MS SQL Server?