May I ask a trigger

54321989

I wrote a trigger as follows, when jlzt like 1111% of resume table, update other fields
In other cases, the update situation is different, but the check syntax is correct, but there is a problem at runtime, help me see.

CREATE TRIGGER [upjlzttojl] ON [dbo]. [Resume]
FOR UPDATE
AS
begin
   if update (jlzt)
   begin
      declare @jlzt varchar (15)
      select @ jlzt = jlzt from updated
      if @jlzt like '1111111111%'
update resume set zjl = 3 from updated where reid = updated.reid
      else if @jlzt like '1111%'
update resume set zjl = 2 from updated where reid = updated.reid
      else if @jlzt like '0000000000%'
update resume set zjl = 0 from updated where reid = updated.reid
      else
update resume set zjl = 1 from updated where reid = updated.reid
   end
   if update (ejlzt)
   begin
      declare @ejlzt varchar (15)
      select @ ejlzt = ejlzt from updated
      if @ejlzt like '1111111111%'
update resume set ejl = 3 from updated where reid = updated.reid
      else if @ejlzt like '1111%'
update resume set ejl = 2 from updated where reid = updated.reid
      else if @ejlzt like '0000000000%'
update resume set ejl = 0 from updated where reid = updated.reid
      else
update resume set ejl = 1 from updated where reid = updated.reid
   end
end

我是杀人狂

begin
   declare @jlzt varchar (15)
     set @ jlzt = jlzt
      select @jlzt from updated
      if @jlzt like '1111111111%'

cv4bf5d65fd

CREATE TRIGGER [upjlzttojl] ON [dbo]. [Resume]
FOR UPDATE
AS
begin
   if update (jlzt)

   begin
      declare @jlzt varchar (15)

      if (select count (1) from updated where jlzt like '1111111111%')> 0
update resume set zjl = 3 from updated where reid = updated.reid
      else if (select count (1) from updated where jlzt like '1111%')> 0
update resume set zjl = 2 from updated where reid = updated.reid
      else if (select count (1) from updated where jlzt like '0000000000%')> 0
update resume set zjl = 0 from updated where reid = updated.reid
      else
update resume set zjl = 1 from updated where reid = updated.reid
   end
   if update (ejlzt)
   begin
      declare @ejlzt varchar (15)
      select @ ejlzt = ejlzt from updated where ejlzt like '1111111111%'
      if (select count (1) from updated where ejlzt like '1111111111%')> 0
update resume set ejl = 3 from updated where reid = updated.reid
      else if (select count (1) from updated where ejlzt like '1111%')> 0
update resume set ejl = 2 from updated where reid = updated.reid
      else if (select count (1) from updated where ejlzt like '0000000000%')> 0
update resume set ejl = 0 from updated where reid = updated.reid
      else
update resume set ejl = 1 from updated where reid = updated.reid
   end
end

我是杀人狂

begin
   declare @jlzt varchar (15)
     set @ jlzt = jlzt
      declare @str nvarchar (1000)
      set @ str = 'select' + @ jlzt + 'from updated'
      exec (@str)
      if @jlzt like '1111111111%'

54321989

Still not working, halo

cv4bf5d65fd

I just saw that there is an updated table. Only inserted and deleted.

cv4bf5d65fd

CREATE TRIGGER [upjlzttojl] ON [dbo]. [Resume]
FOR UPDATE
AS
begin
   if update (jlzt)
   begin
      if (select count (1) from inserted where jlzt like '1111111111%')> 0
update resume set zjl = 3 from inserted where reid = inserted.reid
      else if (select count (1) from inserted where jlzt like '1111%')> 0
update resume set zjl = 2 from inserted where reid = inserted.reid
      else if (select count (1) from inserted where jlzt like '0000000000%')> 0
update resume set zjl = 0 from inserted where reid = inserted.reid
      else
update resume set zjl = 1 from inserted where reid = inserted.reid
   end
   if update (ejlzt)
   begin
      if (select count (1) from inserted where ejlzt like '1111111111%')> 0
update resume set ejl = 3 from inserted where reid = inserted.reid
      else if (select count (1) from inserted where ejlzt like '1111%')> 0
update resume set ejl = 2 from inserted where reid = inserted.reid
      else if (select count (1) from inserted where ejlzt like '0000000000%')> 0
update resume set ejl = 0 from inserted where reid = inserted.reid
      else
update resume set ejl = 1 from inserted where reid = inserted.reid
   end
end

hiqwolfzzh

cv4bf5d65fd
 
 
   
I just saw that there is no updated table, only inserted and deleted.