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

Does index speed up select statements?

1072

What is xdr?

1041

What will be the maximum number of index per table?

1055

How to create nested stored procedure?

1071

Define cross join in sql server joins?

1078

Explain about integration services of Microsoft SQL server?

1083

What are the different authentication modes in sql server? How can it be changed?

1137

What is the difference between value type and reference type?

987

How to loop through result set objects using mssql_fetch_array()?

1130

How to download and install microsoft .net framework version 2.0?

1181

How do I find the sql server version?

1076

How can you control the amount of free space in your index pages?

1100

What is pessimistic concurrency?

1021

How do I run a trace in sql server?

1036

Explain different types of lock modes in sql server 2000?

980