题目内容

TestKing.com uses a SQL Server 2005 database. This database contains a trigger named trg InsertOrders, which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal?()

ALTER TABLE OrdersDISABLE TRIGGER trg InsertOrders
B. DROP TRIGGER trg InsertOrders
C. DISABLE TRIGGER trg InsertOrders ON Orders
D. ALTER TRIGGER trg InsertOrders ON Orders NOT FOR REPLICATION

查看答案
更多问题

附件传动装置的功用是什么?

公民参与政治生活的基本要求是()。

A. 有序的政治参与
B. 依法实行民主选举
C. 依法行政
D. 民主管理,共创幸福生活

3TF47型交流接触器的主触头阻值应()。

一般杀死微生物营养体E值为(),杀死微生物芽孢E值为()以上,一般酶类和纤维素分解的E值为()左右。

答案查题题库