Interested to Buy Any Domain ? << Click Here >> for more details...
How can you get @@error and @@rowcount at the same time?
- 9 Answers
- 23945 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
Explain the steps needed to create a scheduled job?
What are different types of raid levels?
What is a deadlock and what is a live lock?
Mention the command used to rename the database.
Mention the different types of triggers?
What is a db view?
What is serializable?
Explain nested join?
Explain what is use of dbcc commands?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
How do triggers work?
How can you set the threshold at which sql server will generate keysets asynchronously?
How do I find my localdb version?
How data can be copied from one table to another table?
What is the difference between web edition and business edition?
