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

Question Posted / kiranpal singh

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

More SQL Server Interview Questions

Explain intellisense for query editing

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

List out different types of normalizations in sql server and explain each of them?

Define Check points and End Points?

What are SQL Jobs, please mention the use of it and how to create them.

Is SET a SQL Keyword?

How to select top 5 coloumn from a table without using coloumn name

What are different types of table joins?

What is difference between restoration and recovery in SQLServer?

event classes in sql server

Do you have any idea about the tcl commands?

why would you use sql agent? : Sql server database administration

For more SQL Server Interview Questions Click Here