我是菜鸟，请指教，急！急！

Question

写错了，每一个记录的值为100

Answer 1

CREATE TRIGGER  Tr_insert  ON [dbo].[aa] 
FOR INSERT
AS
declare @code bigint  declare @id int
             set @id=(select id from inserted)
            if @id=1 
           begin
                    update aa 
                     set code=100
           end
          else
          begin
                       update aa
                       set code=100+@id-1
                       where id in( select id from inserted )
         end