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 call a function that has out parameter in select statement

0 Answers   Nagarro,

How do you know which index a table is using?

4 Answers  

How to insert a new row into a table with "insert into" statements in ms sql server?

0 Answers  

What is ssl in sql server?

0 Answers  

What is a stored procedure?

3 Answers  

How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change Table,Stored Procd. Then I Find Which SP,Table We Have Edit/Change in Seven Dayes

1 Answers   INDUS,

Can group by be used without aggregate functions?

0 Answers  

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

0 Answers  

What is a non clustered primary key?

0 Answers  

How do I clean up sql server transaction log?

0 Answers  

What are the advantages dts has over bcp?

0 Answers  

What are the purposes of floor and sign functions?

0 Answers