select @@error select @@rowcount

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

Question Posted / laxman

Answer Posted / laxman

select @@error
select @@rowcount

Is This Answer Correct ?

10 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is sql server profiler?

953

How to receive returning result from a query?

1034

What is difference in performance between insert top (n) into table and using top with insert?

969

What is primary key, unique key, and foreign key?

915

Can group functions be mixed with non-group selection fields in ms sql server?

889

How do I start and stop sql server?

965

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

304

What is the template in sql?

916

What is precedence constraint?

922

Explain external key management in sql server 2008

846

What specific conditions database should meet, before you can bulk copy data into it using bcp?

933

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1901

What is blocking?

979

Where are stored procedures in sql server?

1006

What is triggers in ms sql server?

1048