How can you get @@error and @@rowcount at the same time?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / guest

9 Answers
24008 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can you get @@error and @@rowcount at the same time?..

Answer / 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

How can you get @@error and @@rowcount at the same time?..

Answer / gunasekaran k.j

SELECT @@Rowcount as rwCount, @@Error as Er

Is This Answer Correct ?

15 Yes

2 No

How can you get @@error and @@rowcount at the same time?..

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

How can you get @@error and @@rowcount at the same time?..

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

How can you get @@error and @@rowcount at the same time?..

Answer / ramakrishna

this is not answer

Is This Answer Correct ?

4 Yes

3 No

How can you get @@error and @@rowcount at the same time?..

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

How can you get @@error and @@rowcount at the same time?..

Answer / sachin rakshe

Is This Answer Correct ?

0 Yes

0 No

How can you get @@error and @@rowcount at the same time?..

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

How can you get @@error and @@rowcount at the same time?..

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

Post New Answer