How can you get @@error and @@rowcount at the same time?
- 9 Answers
- 22764 Views
- I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What is normalization of database? What are its benefits?
how will add additional conditions in sql?
Difference between drill down and drill through report.
Define inner join in sql server joins?
Explain the dbcc pintable command when would you use it?
What is stored in the mssqlsystemresource database? : sql server database administration
What is table constraint?
How can sql injection be stopped? : sql server security
What is co-related sub query?
what is database replication? : Sql server database administration
What is set nocount on?
How to use wildcard characters in like operations in ms sql server?
How to define the name and server for a new dsn?
What do you mean by normalisation?
User wants only to display only pdf as export option in report manager. How to achieve this?
