22,301
社区成员




update tab set co_num=Right('000000'+cast(row_number() over (order by ... ) as varchar(6)),6)
试试吧
declare @co_num int,
@CoNum varchar(6)
select co_num=count(*)+1 from tab --获取插入数据的序号
SET @CoNum=RIGHT('000000'+cast(@co_num as varchar(6)),6)--转换成需要的格式
--后面自己插入即可