insert tablename select '002',name, gender ..... from tablename where id = '001' ---- ??
declare @maxid int select @maxid=max(convert(int,id)) from 表insert into 表(id, name, gender...) select right('000'+@maxid+convert(int,id),3),name,gender... from 表
寫得通用一點就是declare @a varchar(10),@v varchar(10) set @a='009' set @v=cast(cast(@a as int)+1 as varchar)insert into tablename (id, name, gender) select id=replace(space(len(@a)-len(@v)),' ','0')+@v ,name,gender from tablename where id = @a新的id=010
select '002',name, gender .....
from tablename
where id = '001'
----
??
select @maxid=max(convert(int,id)) from 表insert into 表(id, name, gender...)
select right('000'+@maxid+convert(int,id),3),name,gender... from 表
set @a='009'
set @v=cast(cast(@a as int)+1 as varchar)insert into tablename (id, name, gender)
select id=replace(space(len(@a)-len(@v)),' ','0')+@v
,name,gender from tablename where id = @a新的id=010