select @inserdtcount =count(*)  from inserted
select @inserdtcount =count(*)  from deleted

解决方案 »

  1.   

    select @inserdtcount =count(*)  from inserted
    select @deletedcount =count(*)  from deleted
      

  2.   

    declare
      @inserdtcount int,
      @deletedcount int;
    select @inserdtcount =count(*)  from inserted
    select @deletedcount =count(*)  from deleted
      

  3.   

    declare
      @inserdtcount int,
      @deletedcount int
    select @inserdtcount =count(*)  from inserted
    select @deletedcount =count(*)  from deleted
      

  4.   

    什么条件下触发?declare
      @inserdtcount int,
      @deletedcount int
    select @inserdtcount =count(*)  from inserted
    select @deletedcount =count(*)  from deleted