How can you get @@error and @@rowcount at the same time?
Answers were Sorted based on User's Feedback
Answer / gunasekaran k.j
SELECT @@Rowcount as rwCount, @@Error as Er
Is This Answer Correct ? | 15 Yes | 2 No |
Answer / pankaj
If @@Rowcount is checked after Error checking statement then
it will have 0 as the value of @@Recordcount as it would
have been reset. And if @@Recordcount is checked before the
error-checking statement then @@Error would get reset. To
get @@error and @@rowcount at the same time do both in same
statement and store them in local variable. SELECT @RC =
@@ROWCOUNT, @ER = @@ERROR
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / binoo tiku
@@error variable shows the error number of the last
T-SQL error
@@rowcount variable gives the number of rows affected by
the most recent SQL statements.
Is This Answer Correct ? | 9 Yes | 7 No |
Answer / raji
@@error - displays the error number of last T-Sql statement
@@rowcount - displays the total row count of last T-Sql
statement
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / sachin rakshe
If @@Rowcount is checked after Error checking statement then
it will have 0 as the value of @@Recordcount as it would
have been reset. And if @@Recordcount is checked before the
error-checking statement then @@Error would get reset. To
get @@error and @@rowcount at the same time do both in same
statement and store them in local variable. SELECT @RC =
@@ROWCOUNT, @ER = @@ERROR
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / yjreddy
select @@ROWCOUNT
it will give the no of rows affected by last sql statement
select @@ERROR
it will display the error number for last sql statement
Is This Answer Correct ? | 0 Yes | 3 No |
Answer / 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 |
What do you understand by mirroring?
What is user-defined multi-statement table-valued function?
How to turn on the mssql api module in php?
what are constraints? Explain different types of constraints? : Sql server database administration
Explain system scalar functions?
What are the differences between having and where clause.
Explain primary key in sql server?
I have student marks in a student table. I need second highest mark .Then what will the query for this?
37 Answers NetCore, Patni, SAP Labs, Temenos, Wipro,
What is the use of sign function?
Explain for xml explicit mode?
How to skip remaining statements in a loop block using continue statements?
What is a rollup clause?