select @@ROWCOUNT it will give the no of rows affected by last sql stateme

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

Question Posted / yjreddy

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

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

how can you attach more than 20 ldf files in sql server

1997

What is filestream?

1001

When is the use of update_statistics command?

1001

Find first and last day of current month in sql server

1024

How can we migrate from SQL server to SQL Azure?

113

What is collation?

1138

What are trace files?

950

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1066

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

1070

How to create a dml trigger using create trigger statements?

1031

do views contain data ?

961

What is 3nf normalization?

990

How to apply cascading referential integrity in place of triggers?

1032

What is the difference between a "where" clause and a "having" clause?

1160

When a primary key constraint is included in a table, what other constraints does this imply?

985