触发器

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' --所有表