How can you get @@error and @@rowcount at the same time?
- 9 Answers
- 22771 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramakrishna
DECLARE @RC int
DECLARE @ER int
INSERT INTO T(Cal1,Col2..)
SELECT ColX,ColY..
FROM T1
SELECT @RC = @@ROWCOUNT
SELECT @ER = @@ERROR
| Is This Answer Correct ? | 3 Yes | 16 No |
Post New Answer View All Answers
What is the process of normalization?
What is the partitioning method?
What are SSL and TSL protocols?
What is the difference between executequery () and executeupdate ()?
Difference between 2NF &3NF ?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
Why we use functions in sql server?
What is the difference between dbcc indexdefrag and dbcc reindex?
What are different types of raid levels?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Explain view in sql server?
How many types of the database links?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is nonclustered index with included columns ?
What are the types of processing and explain each? : sql server analysis services, ssas
