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

How to list all objects in a given schema?

0 Answers  


What is the downside of using udf?

0 Answers  


How to configure and test odbc dsn settings?

0 Answers  


Can you link only other SQL Servers or any database servers such as Oracle?

1 Answers  


do views contain data ?

0 Answers   MCN Solutions,






How send email from database?.

3 Answers   CarrizalSoft Technologies, Merrill Lynch,


What are the steps you can take to avoid “deadlocks”?

0 Answers  


Which is best Subquery (or) joins in sql server? explain why

2 Answers  


Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  


what are cursors? : Sql server database administration

0 Answers  


Write a SQL query in order to merge two different columns into single column?

0 Answers   QuestPond,


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,


Categories