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 tempdb in sql server?

967

What is the standby server?

946

Do you know what is blocking?

944

Write a sql query to sort on different column name according to the parameters passed in the function?

892

What are the triggers in sql?

1094

Is resultset an interface?

956

What is a data source file?

965

Why we need sql server?

956

What does indexation mean?

968

What is normalization and what are the advantages of it?

975

Can we take the full database backup in log shipping?

938

What is an execution plan? When would you use it?

970

Data table as parameter in sql server?

1039

What are triggers? How do you invoke a trigger on demand?

1307

What is the use of floor function in sql server?

1074