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 |
Write a sql query to delete duplicate records from a table called table1
how to change column into row in sql
What is the purpose of grouping data in a report?
wat is the main diff between sql server 2000and sql server 2005
What is acid mean in sql server?
How to drop an existing stored procedure in ms sql server?
Does sql server use java?
What is the difference between lock, block and deadlock? : sql server database administration
What do you mean by acid?
What is the meaning of resultset type_scroll_insensitive?
i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..
What are the advantages of using views. Why do we need views when we have SPs?