怎么通过系统表(而不OBJECTPROPERTY函数)知道触发器的类型?(UPDATE,DELETE,INSERT或它们的组合)
---------------------------------------------------------------
SELECT NAME,CASE WHEN
STATUS & 0X2000<>0 THEN 'Y' ELSE NULL END AS [INSTEAD OF],
CASE WHEN
STATUS & 0X400<>0 THEN 'Y' ELSE NULL END AS [INSERT],
CASE WHEN
STATUS & 0X100<>0 THEN 'Y' ELSE NULL END AS [DELETE],
CASE WHEN
STATUS & 0X200<>0 THEN 'Y' ELSE NULL END AS [UPDATE]
FROM SYSOBJECTS
WHERE TYPE='TR'