CREATE TRIGGER SHDD ON [dbo].[DDSH]  
FOR INSERT,UPDATE
AS
begin

  update [SCRWTZD] set [SH] = 1
  where [DDH] in (
    select [DDH] from inserted where [YWJL] = 6 and [WLB] = 6 and [PZB] = 6 and [ZJL] = 6 and [SCB] = 6 and [GCJSB] = 6
  )
  
  update [SCRWTZD] set [SH] = 0
  where [DDH] in (
    select [DDH] from inserted where [YWJL] <> 6 or [WLB] <> 6 or [PZB] <> 6 or [ZJL] <> 6 or [SCB] <> 6 or [GCJSB] <> 6
  )
  
end

------解决方案--------------------
SQL code

CREATE TRIGGER SHDD ON [dbo].[DDSH]  
FOR INSERT,UPDATE
AS
begin

  
  update [SCRWTZD] set [SH] = case when i.[DDH]=6 and i.[YWJL]=6 and ....
  then 1 else 0 end from inserted i where i.[DDH]=[SCRWTZD].[DDH]
 
 end
 --你的更新只能更新一行数据

------解决方案--------------------
declare @DDH nchar 后面没有定义 nchar为几位的话，默认为1。
假如字长为10，那么需要这样定义：nchar(10)


------解决方案--------------------
SQL code

CREATE TRIGGER SHDD ON [dbo].[DDSH]  
FOR INSERT,UPDATE
AS
begin
  update [SCRWTZD] 
        set [SH]=1 
        from inserted i,[SCRWTZD] s where i.[DDH]=s.[DDH] 
            and i.[YWJL]=6 and i.[WLB]=6 and i.[PZB]=6 
            and i.[ZJL]=6 and i.[SCB]=6 and i.[GCJSB]=6;
  update [SCRWTZD] 
        set [SH]=0
        from inserted i,[SCRWTZD] s where i.[DDH]=s.[DDH] 
            and (isnull(i.[YWJL],0)<>6 or isnull(i.[WLB],0)<>6 or isnull(i.[PZB],0)<>6
            or isnull(i.[ZJL],0)<>6 or isnull(i.[SCB],0)<>6 or isnull(i.[GCJSB],0)<>6);
end