触发器

ALTER trigger [转移单单身工单单号的控制] on [dbo].[SFCTC] 

for insert,update

as 

declare @order nvarchar(500)

select @order=isnull(@order+',','')+TA002 from MOCTA,inserted  

       where MOCTA.TA001 = inserted.TC004 and MOCTA.TA006=inserted.TC047  

             and MOCTA.TA011 in ('2','3') and inserted.TC005 >MOCTA.TA002

set @order='还有比这个更早日期的工单，请按日期先后来转移，工单号码为:'+@order

begin

    

    if exists(select 1 from MOCTA,inserted where MOCTA.TA001 = inserted.TC004

        and MOCTA.TA006=inserted.TC047 

        and inserted.TC005 >MOCTA.TA002 and MOCTA.TA011 in ('2','3'))

    begin



        raiserror(@order,16,1)

        rollback transaction

        return

    end



end