触发器还是有有关问题 不能执行插入和更新用做变量表名得到的表

触发器还是有问题 不能执行插入和更新用做变量表名得到的表
还是有问题 不能执行插入和更新用做变量表名得到的表

提示为:第 1 行: 'adlishi' 附近有语法错误。


代码如下
CREATE TRIGGER tougao ON yichangxinwen  
instead of insert 
as 
declare @biaoming varchar(200)  

if (select quanxian from denglu where yonghu = (select yonghu from inserted)) = '编辑' 
begin 
set @biaoming = 'adlishi' 
end 

else if (select quanxian from denglu where yonghu = (select yonghu from inserted)) = '通讯员' 
begin 
set @biaoming = 'txlishi' 
end 

else if (select quanxian from denglu where yonghu = (select yonghu from inserted)) = '本台记者' 
begin 
set @biaoming = 'bjlishi' 
end 

else if (select quanxian from denglu where yonghu = (select yonghu from inserted)) = '集体记者' 
begin 
set @biaoming = 'jjlishi' 
end 


if exists(select * from yichangxinwen where yonghu = (select yonghu from inserted) and nianyue = (select convert(char(7),getdate(),20)) ) 
begin 

  insert yichangxinwen(biaoti,wenzhang,select1,yonghu,select2,yonghu2,shijian,nianyue,shenghe,danwei,riqi,canshu) 
  select biaoti,wenzhang,select1,yonghu,select2,yonghu2,shijian,nianyue,shenghe,danwei,riqi,canshu from inserted; 
  exec('update'''+ @biaoming+ '''set touzong=touzong+1 
  from '''+@biaoming+''' inner join inserted yichangxinwen on '''+@biaoming+'''.yonghu =  
  yichangxinwen.yonghu and '''+@biaoming+'''.nianyue = (select convert(char(7),getdate(),20)) 
  ') 
end 

else 
begin 
   
  insert yichangxinwen(biaoti,wenzhang,select1,yonghu,select2,yonghu2,shijian,nianyue,shenghe,danwei,riqi,canshu) 
  select biaoti,wenzhang,select1,yonghu,select2,yonghu2,shijian,nianyue,shenghe,danwei,riqi,canshu from inserted; 
  exec('insert '''+@biaoming+'''(yonghu,nianyue,touzong) 
  select yonghu,convert(char(7),getdate(),20),1 from inserted') 
end 

请大家帮忙看看吧!!!!!


[解决办法]

SQL code

--这个问题贴了两次。且很多人都指出了错误处，楼主仍然犯这个错。无语。。。。。CREATE TRIGGER tougao  ON yichangxinwen   instead   of  insert  as  declare  @biaoming  varchar(200)   declare @t table(yonghu varchar(200) ,nianyue varchar(200) ,touzong varchar(200))if (select quanxian from denglu where yonghu = (select yonghu  from inserted)) = '编辑'  begin  set @biaoming = 'adlishi'  end  else if (select quanxian from denglu where yonghu = (select yonghu  from inserted)) = '通讯员'  begin  set @biaoming = 'txlishi'  end  else if (select quanxian from denglu where yonghu = (select yonghu  from inserted)) = '本台记者'  begin  set @biaoming = 'bjlishi'  end  else if (select quanxian from denglu where yonghu = (select yonghu  from insertedfro