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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Does sql server 2016 have ssms?

519


How to include text values in sql statements?

592


How many types of keys are there?

530


What is use of attributehierarchyenabled? : sql server analysis services, ssas

615


What is serializable?

673






When would you prefer to have a minimum number of indexes?

509


What are the encryption mechanisms in sql server?

578


What is the dbcc command and why is it used?

573


What are various aggregate functions that are available?

510


Can binary strings be converted into numeric or float data types?

561


How to drop existing views from a database in ms sql server?

534


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1436


Can I use sql azure as a backup with log shipping or database mirroring?

136


how would you improve etl (extract, transform, load) throughput?

550


What is transaction server isolation?

580