How can you get @@error and @@rowcount at the same time?
- 9 Answers
- 22768 Views
- I also Faced
- E-Mail Answers
Answer Posted / gunasekaran k.j
SELECT @@Rowcount as rwCount, @@Error as Er
| Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
Can we write ddl in trigger?
How to use subqueries with the exists operators in ms sql server?
What is cursor in ms sql server?
What is collation sensitivity? Explain different types.
How to scale out a federation by Sql statement?
Explain transaction server implicit?
Do you know nested transaction?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
What is filtered index?
What are the different authentication modes in sql server?
What is difference between standardization and normalization?
What area unit the various kinds of info compression introduced in sql server 2008?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
explain different levels of normalization? : Sql server database administration
What the difference between UNION and UNIONALL?
