create tigger tr on table1 for insert as begin update table1 set column1='name' + cast(autoid as varchar(20)) where autoid in (select autoid from inserted) end--autoid为你这个表的自增字段
to 浮云游子 那还不如用计算字段在设计表-->新建一字段-->下面的“公式”属性--> 'name'+cast(id as varchar(10))
for insert
as
begin
update table1 set column1='name' + cast(autoid as varchar(20))
where autoid in (select autoid from inserted)
end--autoid为你这个表的自增字段
那还不如用计算字段在设计表-->新建一字段-->下面的“公式”属性--> 'name'+cast(id as varchar(10))