How can you get @@error and @@rowcount at the same time?
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
What is transaction server isolation?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
What is data set in report?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What is a cache in ssrs?
How to create an multi-statement table-valued function?
What is difference between standardization and normalization?
Where views are stored in sql server?
What is a primary index?
What are the advantages of partitioning?
How do I determine how many instances of sql server are installed on a computer?
What is Dependency Injection and provide example?
What are different types of views?
What is primary key, unique key, and foreign key?