set nocount on

Create table #y (Trname varchar(50),txt text)

select name, iid = identity(int,1,1) into #x from SysObjects where xtype = 'TR'

declare @i int, @max int

declare @name varchar(50)

set @i = 1

select @max = max(iid) from #x

while @i <= @max

begin

select @name = name from #x where iid = @i

insert #y (txt)

exec('sp_helptext ' + @name)

update #y

set Trname=@name

where Trname is null

set @i = @i + 1

end

select * from #y where txt LIKE '%采购%'

drop table #x

drop table  #y

set nocount off

select triggers.name as [触发器],tables.name as [表名度],triggers.is_disabled as [是否禁用知],
triggers.is_instead_of_trigger AS [触发器类型道版],
case when triggers.is_instead_of_trigger = 1 then 'INSTEAD OF'
when triggers.is_instead_of_trigger = 0 then 'AFTER'
else null
end as [触发器类型描权述]
from sys.triggers triggers
inner join sys.tables tables on triggers.parent_id = tables.object_id
where triggers.type ='TR' and triggers.name like '%mycyy%'
order by triggers.create_date