insert 触发器

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER trigger [tri_subdata] on [dbo].[T_SUPERVISE_SUBDATA] for insert as
begin
	declare @date varchar(10),@limit int,@i int
	set @i=1  --不包含当天时间则改为0
	select @date=substring(A.accept_time,1,10),@limit=A.xbts from inserted A 
	if isnull(@date,'')<>'' and isnull(@limit,-1)<>-1
	begin
		--设为简体中文
		set language N'Simplified Chinese'
		--如果为周末或其它假期
		if datename(weekday,@date)='星期六' or datename(weekday,@date)='星期日'
			set @limit=@limit+1
		else if exists (select * from FE_BASE1026..SYS_HOLIDAY where substring(SH01,1,10)=@date)
			set @limit=@limit+1
		while(@i<@limit)
		begin
			--日期加1天
			set @date=convert(varchar(10),DATEADD(day,1,@date),20) 
			if datename(weekday,@date)='星期六' or datename(weekday,@date)='星期日'
				set @limit=@limit+1
			else if exists (select * from FE_BASE1026..SYS_HOLIDAY where substring(SH01,1,10)=@date)
				set @limit=@limit+1
			set @i=@i+1
		end
		--修改限办日期
		update FE_APP1026..T_SUPERVISE_SUBDATA set limit_time=@date where guid=(select guid from inserted)
	end
end