How do you find the error, how can you know the number of
rows effected by last SQL statement?
- 2 Answers
- 8420 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandra rekha
select @@error'Error'
select @@rowcount'Rows'
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain logical operators in sql server?
What is the use of stored procedure?
Which table keeps the locking information?
What are the encryption mechanisms in sql server?
What are the features of Embedded SQL
Explain system functions or built-in functions? What are different types of system functions?
What are built in functions?
What is meant by indexing files?
Tell me about the approaches which you used to counter the DI problems.
What is the cartesian product of the table?
What are the components of sql server service broker?
Define a cross join?
What are the purposes of floor and sign functions?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
