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

Answer / gunasekaran k.j

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

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

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.

Answer / ramakrishna

this is not answer

Answer / raji

@@error - displays the error number of last T-Sql statement
@@rowcount - displays the total row count of last T-Sql
statement

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

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

Answer / ramakrishna

DECLARE @RC int
DECLARE @ER int

INSERT INTO T(Cal1,Col2..)
SELECT ColX,ColY..
FROM T1

SELECT @RC = @@ROWCOUNT
SELECT @ER = @@ERROR

Can we store videos inside the sql server table?

0 Answers  

How many types of cursors are there in SQL Server?

5 Answers   247Customer, CarrizalSoft Technologies,

What is a raid and what are different types of raid configurations?

0 Answers  

What is full outer join in sql server joins?

0 Answers  

Write a query to get all details of employee who has maximum salary from employee table

8 Answers   AON, Genpact,

How to disconnect from a sql server using mssql_close()?

0 Answers  

How do you fine the performance tunning?

2 Answers   Accenture,

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,

What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,

What are the benefits of normalization?

0 Answers  

What is the meaning of resultset type_scroll_insensitive?

0 Answers  

What new changes are being made in SQL Server?

0 Answers   Blue Star,