试题详情
- 多项选择题 Your company 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?（）
A、 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
E、 sp_settriggerorder@triggername= 'trg_InsertOrders', @order='None'
关注下方微信公众号，在线模考后查看
热门试题
- Certkiller。COM单个域的Ac
- Your organization h
- Your company runs R
- You have
- You need
- Your network&e
- You have a DHCP serv
- Your company has an
- You have
- You have a DHCP ser
- Your network&e
- You have
- You work
- You have a
- Your network&e
- Your company runs R
- Your company has a n
- Your company has a s
- You have̳
- You are e