列举 TRIGGER:
SELECT * FROM dbo.sysobjects WHERE xtype = 'TR' 或
SELECT * FROM dbo.sysobjects where OBJECTPROPERTY(id, N'IsTrigger') = 1获得 TRIGGER 代码:
select text from dbo.syscomments where id = object_id(N'[dbo].[TRIGGER名]')
SELECT * FROM dbo.sysobjects WHERE xtype = 'TR' 或
SELECT * FROM dbo.sysobjects where OBJECTPROPERTY(id, N'IsTrigger') = 1获得 TRIGGER 代码:
select text from dbo.syscomments where id = object_id(N'[dbo].[TRIGGER名]')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货