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

What are magic tables in sql server?

1133

Can a table be moved to different filegroup?

976

What are the advantages of passing name-value pairs as parameters?

1168

What are four major operators that can be used to combine conditions on a where clause?

1054

Write a program to fetch first 10 records from a file?

1011

what is the maximum size of a row? : Sql server database administration

1014

How do I start sql server?

974

Tell me extended events in sql server 2008?

996

How do you drop an index?

924

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

1131

What security features are available for stored procedure?

1036

Can a rule be bound to any column of any data type?

963

What is a partition function in sql server?

1134

What is normalization of database?

1105

What is the order by used for?

1024