declare @tb table(ID int, NAME varchar(100))
insert into @tb select 1,'100000'
insert into @tb select 1,'010010'
insert into @tb select 2,'000100'select ID,right('000000'+cast(sum(cast(name as int)) as varchar(6)),6)sum_name from @tb
group by id10进制数.
如果是2进制数字,那另当别论
insert into @tb select 1,'100000'
insert into @tb select 1,'010010'
insert into @tb select 2,'000100'select ID,right('000000'+cast(sum(cast(name as int)) as varchar(6)),6)sum_name from @tb
group by id10进制数.
如果是2进制数字,那另当别论
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货