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

Answer Posted / laxman

select @er=@@error,@rc=@@rowcount

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a traditional network library for sql servers? : Sql server database administration

637


What command must you use to include the not null constraint after a table has already been created?

756


What is service broker?

767


Explain “not null constraint” in sql server?

723


What are click through reports?

118






How to create an index on an existing table in ms sql server?

676


What are the disadvantages of indexes?

702


How to link tables in sql server?

658


What is msdb database? : SQL Server Architecture

736


How do I start sql server agent automatically?

690


How to update values in a table with update statements in ms sql server?

739


What is a Join and explain its types?

802


What is logon trigger?

716


What are the advantages of using third-party tools?

720


How to list all stored procedures in the current database using ms sql server?

813