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

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

Question Posted / gunasekaran k.j

Answer Posted / gunasekaran k.j

Is This Answer Correct ?

15 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Differentiate between a having clause and a where clause.

958

What is the use of @@spid?

993

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169

What is nested transaction?

1089

What is the chart in report?

158

What are points to remember while using the fillfactor argument?

961

List out a number of the wants to setup a SQL Server failover cluster?

1055

What is the architecture of ms sql reporting service?

977

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

873

What are the rules to use the rowguidcol property to define a globally unique identifier column?

1005

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

986

Can binary strings be used in arithmetical operations?

921

What are the advantages to use stored procedures?

1097

What are the dis_advantages of stored procedures, triggers, indexes?

2210

How to connect of datebase with sql express.?

1092