http://www.cnblogs.com/hoojo/archive/2011/07/20/2111316.html
if (object_id('tgr_MedSendRecord_update', 'TR') is not null)
drop trigger tgr_MedSendRecord_update
go
create trigger tgr_MedSendRecord_update on MedSendRecord for update
as
BEGIN
declare @strPre varchar(100)
declare @strFlag varchar(1)
declare cur_pre cursor for select PrescriptionNo from inserted
select @strFlag=BasketState from inserted
open cur_Insert
fetch next from cur_pre into @strPre
while @@fetch_status=0
begin
--更新后的数据
update XJPrescription set BasketState = @strFlag where PrescriptionNum= @strPre;
fetch next from cur_pre into @strPre
end
close cur_pre
deallocate cur_pre
END
select name from sysobjects where xtype='TR' --所有触发器
exec sp_helptext 'tgr_MedSendRecord_update' --查看具体触发器内容
select name from sysobjects where xtype='P' --所有存储过程
select name from sysobjects where xtype='V' --所有视图
select name from sysobjects where xtype='U' --所有表