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

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

1062

What is a synonym for manipulation?

1005

What have included columns when we talk about sql server indexing?

1040

What are diverse clauses that form a part of sql?

1072

Does index speed up select statements?

1017

what are the new features in SSRS?

134

Explain what are the events recorded in a transaction log?

1008

What are the events recorded in a transaction log?

1002

How to use “drop” keyword in sql server and give an example?

1134

Different types of keys in SQL?

1103

What is parameterized reports in ssrs ?

150

What is the new security features added in sql server 2014? : sql server security

1009

What is a performance monitor?

977

Tell about MOM Tool(Microsoft Operator Manager)?

1917

What do you mean by table and field in sql?

1017