How can you get @@error and @@rowcount at the same time?
- 9 Answers
- 22769 Views
- I also Faced
- E-Mail Answers
Answer Posted / laxman
SELECT @RC = @@ROWCOUNT
SELECT @ER = @@ERROR
if we use above statements then @@error will be reset with
0.
i think right one is
select @er=@@error,@rc=@@rowcount
| Is This Answer Correct ? | 31 Yes | 1 No |
Post New Answer View All Answers
How to execute a stored procedure in ms sql server?
Which language is supported by sql server?
What are the recovery models for a database?
What are approximate numeric data types in ms sql server?
What are the drawbacks of reporting in ssrs?
What are the advantages of log shipping?
How to backup encryption key ?
What are different backups available in sql server?
How to enter binary string literals in ms sql server?
How to connect php with different port numbers?
What is amo? : sql server analysis services, ssas
Explain in brief about Microsoft SQL server?
what is the sql equivaent of the dataset relation object ?
What does man by sql wildcard characters in sql server?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
