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

Why I can not enter 0.001 second in date and time literals in ms sql server?

0 Answers  


What is difference between stored procedure and function?

3 Answers   L&T,


How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

0 Answers  


Differentiate between a primary key and a unique key.

0 Answers  


What is an execution plan? How would you view the execution plan?

0 Answers  






What is a hint?

0 Answers  


How to add more data to the testing table in ms sql server?

0 Answers  


how do u do Performance tunning ?

1 Answers   Infodat Technologies, Satyam,


How to display a past time in days, hours and minutes?

0 Answers  


Which system table contains information on constraints on all the tables created?

2 Answers  


What is a with(nolock)?

0 Answers  


Explain what is use of dbcc commands?

0 Answers  


Categories