DECLARE @RC int DECLARE @ER int INSERT INTO T(Cal1,Col2..) SELECT ColX

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

Question Posted / ramakrishna

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

Please Help Members By Posting Answers For Below Questions

How to set a database state to offline in ms sql server?

1111

What is self join in sql server joins?

1121

Explain the rules for designing files and file groups in sql server?

1024

What is primary key index?

1022

What are the new features in sql server 2016?

1039

What is temporary stored procedure?

999

What are the grouping functions?

981

how many bits ip address consist of? : Sql server database administration

950

wat wil hapn if we give the both read and deny read permission to user?

2161

What is an expression in ms sql server?

1151

What is sql server agent and what are the two modes of authentication in sql server?

1116

How to achieve Paging of records in SQL SERVER?

1156

What is resource governor in sql server?

1055

What is an inner join?

1050

What is tablesample?

1185