How do you find the error, how can you know the number of
rows effected by last SQL statement?
- 2 Answers
- 8227 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
What is the size of transaction log file?
Tell me what do you understand by a view? What does the with check option clause for a view do?
explain different types of constraints? : Sql server database administration
What is the Control Flow in SSIS
How to make a column nullable?
what's the difference between a primary key and a unique key? : Sql server database administration
What is the difference between a primary key and a unique key? Are they the same?
What are the source of constraints?
What happens to a statement batch if there is a compilation error?
explain the storage models of olap? : Sql server database administration
How you can get a list of all the table constraints in a database?
What is inner join? Explain with an example?
Which are the important points to note when multilanguage data is stored in a table?
How many null values we can have in a unique key field in sql server?
What is acid mean in sql server?
