超出存储过程、函数、触发器或视图的最大嵌套层数（最大层数为32） 超出存储过程、函数、触发器或视图的最大嵌套层数（最大层数为32） USE [ksoa_pf]
GO
/****** 对象: ?Trigger [dbo].[trg_spkfk_update] ? ?脚本日期: 12/04/2014 11:23:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[trg_spkfk_update] ON [dbo].[spkfk]
FOR UPDATE
AS
if update(spid) or update(spbh) or update(spmch) or update(zjm) or update(beactive) or update(dw) or update(shpchd) or update(shpgg)
or update(shengccj) or update(pizhwh) or update(jixing) or update(leibie) or update(jlgg) or update(zengp) or update(zsshlv) or update(xsshlv)
begin
declare @spid char(11)
select @spid = spid from inserted
if not exists(select 1 from spkfk_ncsk where spid = @spid)
begin
insert into spkfk_ncsk
(spid,spbh,spmch,zjm,beactive,denglrq,dw,shpchd,shpgg,shengccj,pizhwh,jixing,leibie,jlgg,shlv,username,zengp,zsshlv,xsshlv,ZT,cwzt)
?select spid,spbh,convert(char(80),spmch),convert(char(20),zjm),beactive,denglrq,dw,convert(char(80),shpchd),convert(char(60),shpgg)
,convert(char(80),shengccj),convert(char(60),pizhwh),convert(char(20),jixing),convert(char(20),leibie),jlgg,0 as shlv,username,zengp
,zsshlv,xsshlv,'N' as ZT,'N' as cwzt
?from inserted
end
else
begin
update a set
? ? ?a.spid = b.spid ,a.spbh = b.spbh ,a.spmch = convert(char(80),b.spmch) ,a.zjm = convert(char(20),b.zjm) ,a.beactive = b.beactive
? ? ,a.denglrq = b.denglrq ,a.dw = b.dw ,a.shpchd = convert(char(80),b.shpchd) ,a.shpgg = convert(char(60),b.shpgg) ,a.shengccj = convert(char(80),b.shengccj)
? ? ,a.pizhwh = convert(char(60),b.pizhwh) ,a.jixing = convert(char(20),b.jixing),a.leibie = convert(char(20),b.leibie) ,a.jlgg = b.jlgg ,a.shlv = 0,a.username = b.username,a.zengp = b.zengp
,a.zsshlv = b.zsshlv,a.xsshlv = b.xsshlv
,a.ZT = 'N',a.cwzt = 'N'
?from spkfk_ncsk a,inserted b
?where a.spid = b.spid
end
end
update a set ?a.zjm=(dbo.GetZjm(a.spmch))
? ? ?from spkfk a,inserted b
? ? ?where a.spid=b.spid
