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

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

Question Posted / gunasekaran k.j

9 Answers
24546 Views
I also Faced
E-Mail Answers

Answer Posted / gunasekaran k.j

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

Is This Answer Correct ?

15 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Detail about the hardware which is supported by SQL server?

1128

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1129

Explain ms sql server reporting services vs crystal reports?

987

What are the types of subquery?

1110

List out what other servers you can use with ssrs?

149

What is the maximum size of a dimension? : sql server analysis services, ssas

1102

Why use “pivot” in sql server?

1190

1 01 101 01010

2110

Explain about the command-line tool SQLCMD?

1161

What is the difference between clustered index and primary key?

976

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

964

What are system databases into sql server (2005/2008) : sql server database administration

1055

Can you create a logon trigger in sql server 2005 express edition?

1132

What is save transaction and save point?

1268

What are distinctive joins find as a part of sql?

1015