How can you get @@error and @@rowcount at the same time?
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 the difference between upgrade and migration in sql server?
Where sql server user names and passwords are stored in sql server? : sql server database administration
Tell me what is log shipping?
Explain what is log shipping?
What is the main difference between ‘between’ and ‘in’ condition operators?
What is merge statement?
Explain foreign key in sql server?
What does the on update no action do?
How to Update from select query in sql server?
How to check table values in sql server?
What is the purpose of linked server configuration in sql server?
Does a full backup include transaction log?
How would you use user_constraints table in DB?
To which devices can a backup be created and where should these devices be located? : sql server management studio
Can we use custom code in ssrs?