Interested to Buy Any Domain ? << Click Here >> for more details...
How can you get @@error and @@rowcount at the same time?
- 9 Answers
- 24507 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 filestream?
What is the meaning of resultset type_scroll_insensitive?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What is logshipping and its purpose?
Explain relational data?
What do you understand by mirroring and mention the advantages of the mirroring?
What is the use of @@spid?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
Why use cursor in sql server?
Can you please explain the difference between function and stored procedure?
How do I create a partition table in sql server?
What is the maximum size per database for sql server express?
What is an identity?
what are the new features introduced in sql server 2000? : Sql server database administration
