A trigger May Not issue A TCL statement like COMMIT,ROLLBACK,SAVEPOINT. So

IF i write before / after insert / update trigger and i do
rollback what will happen?

Question Posted / debasis mohanty

Answer Posted / debasis mohanty

A trigger May Not issue A TCL statement like COMMIT,ROLLBACK,SAVEPOINT.
So U Cant Write A TCL Command Inside A trigger.

Is This Answer Correct ?

10 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are the operators in sql?

1025

What is localdb mssqllocaldb?

1066

What is record data type?

908

What are field types?

997

How do I view an execution plan in sql?

979

How many primary keys can a table have?

1005

How to use sql*plus built-in timers?

1193

What is union, minus and interact commands?

1288

What do you understand by pl/sql cursors?

1084

How do I view a sql trace file?

1024

Which tcp/ip port does sql server run?

998

How do you select unique values in sql?

997

What is rownum in sql?

1039

What is data type in database?

986

What is the use of prepared statement?

1007