自动添加? 你要怎样的自增规则? 增加字段: alter table A add EE varchar(100)
如果表里没有数据,可以用insert触发器来维护
declare @i int set @i=1 while @i<=11111111 begin insert into 表 select '字段A','字段B','字段C','字段D',@i set @i=@i+1 end
alter table A add EE varchar(20) godeclare @i int set @i=1 update A set EE='420502'+right('00000000'+rtrim(@i),0),@i=@i+1 go create trigger trg_A on A for insert as begin declare @i int select @i=isnull(cast(max(right(EE,8)) as int),0) from A update A set EE='420502'+right('00000000'+rtrim(@i),0),@i=@i+1 where isnull(EE,'')='' end go
你要怎样的自增规则?
增加字段:
alter table A add EE varchar(100)
declare @i int
set @i=1
while @i<=11111111
begin
insert into 表 select '字段A','字段B','字段C','字段D',@i
set @i=@i+1
end
godeclare @i int
set @i=1
update A set EE='420502'+right('00000000'+rtrim(@i),0),@i=@i+1
go
create trigger trg_A
on A
for insert
as
begin
declare @i int
select @i=isnull(cast(max(right(EE,8)) as int),0) from A
update A set EE='420502'+right('00000000'+rtrim(@i),0),@i=@i+1 where isnull(EE,'')=''
end
go