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

Do you know the cursor optimization tips?

965

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

965

What is subreport?

141

How to make a column nullable?

1092

How to encrypt data between dialogs?

1076

what is the main function of a query parameter?

152

What is the difference between osql and query analyzer?

973

How do I find the port number for sql server?

955

Tell me about builtinadministrator?

981

what is database replication? : Sql server database administration

1041

How many types of objects are there?

987

What are the different kinds of ssrs reports?

212

Can another user execute your local temporary stored procedures?

967

What is the difference between sdf and mdf?

1281

Find first and last day of current month in sql server

1008