题目内容:
在SQL Server 2008中,设表T(a, b)上建有如下触发器:CREATE TRIGGER tri_update ON T FOR UPDATE AS
IF EXISTS(SELECT * FROM inserted
WHERE b not between 0 and 100)
ROLLBACK
设表T中已有数据:('a01',90),如果执行语句:
UPDATE T SET b = 100 WHERE a = 'a01'
则触发器临时工作表及执行完该语句后表T中的数据为( ) A.T表:('a01',100)
INSERTED表:('a01',90)
DELETED表:('a01',100)
B.T表:('a01',90)
INSERTED表:('a01',90)
DELETED表:('a01',100)
C.T表:('a01',100)
INSERTED表:('a01',100)
DELETED表:('a01',90)
D.T表:('a01',90)
INSERTED表:('a01',100)
DELETED表:('a01',90)
参考答案:
答案解析: