What will happen when a Rollback statement is executed inside a trigger?



What will happen when a Rollback statement is executed inside a trigger?..

Answer / pramod singh

Adaptive Server aborts the currently executing command and halts execution of the rest of the trigger

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Explain few of the new features of sql server 2008 management studio

0 Answers  


Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  


What is inline table-value user-defined function?

0 Answers  


Explain atomicity?

0 Answers  


explain different types of backups avaialabe in sql server? : Sql server database administration

0 Answers  






What are types of subqueries?

0 Answers  


How do I perform an unattended install of sql server 2000?

0 Answers  


Why the trigger fires multiple times in single login?

0 Answers  


What is normalization and its forms?

4 Answers   Challenger Financial,


What are the differences between having and where clause.

0 Answers  


What are the type of joins? When do we use Outer and Self joins?

3 Answers  


What do mean by xml datatype?

0 Answers  


Categories