select @er=@@error,@rc=@@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

Is This Answer Correct ?

5 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to concatenate two character strings together?

1058

What is the contrast amongst drop and truncate?

981

Can we check locks in database? If so, how can we do this lock check?

895

How exceptions can be handled in sql server programming?

952

Explain about temporary stored procedure?

936

What is the use of sql profiler in sql server 2012?

843

Please explain what is “asynchronous” communication in sql server service broker?

880

How to achieve Paging of records in SQL SERVER?

1036

Tell me what do you understand by a view? What does the with check option clause for a view do?

956

What's new in sql management studio for sql server? : sql server management studio

996

How to stop a loop early with break statements in ms sql server?

976

What is query parameter in ssrs?

143

How to select some specific columns from a table in a query in ms sql server?

946

Explain what is lock escalation?

989

Do you think BCNF is better than 2NF & 3NF? Why?

1226