How do you find the error, how can you know the number of
rows effected by last SQL statement?
Answer Posted / chandra rekha
select @@error'Error'
select @@rowcount'Rows'
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What happens if you add a new index to large table?
What is report server project?
what protocol both networks use? : Sql server database administration
Explain partitioned view?
what purpose does the model database serve? : Sql server database administration
What is instead of dml trigger?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
What is the difference between the 2 operating modes of database mirroring?
Tell me what is a linked server?
what is the different types of backups available in sql server? : Sql server database administration
How do I find sql server instance name?
What is page in sql server?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
What is replication with database mirroring? : sql server database administration