create table #表1(A varchar(10),B varchar(50),C varchar(50),D int )
insert #表1 select
'aa','aa00001','aa00100',100
我想用select 语句查询的得到的结果如下:
aa,aa00001,aa00101
这样怎么写select
insert #表1 select
'aa','aa00001','aa00100',100
我想用select 语句查询的得到的结果如下:
aa,aa00001,aa00101
这样怎么写select
insert #表1 select 'aa ', 'aa00001 ', 'aa00100 ',100 select rtrim(A)+','+rtrim(B)+','+rtrim(C)+','+rtrim(D) from #表1drop table #表1
=====================================
aa,aa00001,aa00100,100
select A,B,left(c,6)+'1' as C from #表1
create table #表1(A varchar(10),B varchar(50),C varchar(50),D int )
insert #表1 select 'aa ', 'aa00001 ', 'aa00100 ',100 select rtrim(A)+ ', '+rtrim(B)+ ', '+rtrim(C)+ ', '+rtrim(D) from #表1 drop table #表1
=====================================
aa,aa00001,aa00100,100
create table #表1(A varchar(10),B varchar(50),C varchar(50),D int )
insert #表1 select 'aa ', 'aa00001 ', 'aa00100 ',100 select rtrim(A)+','+rtrim(B)+','+left(rtrim(C),6)+'1,' from #表1drop table #表1
还有,能不能帮我解析一下这个语句:
B是一个字段,是INT类型的
select top 1 B-1 from @ta tb where ta.A=tb.A and ta.id <tb.id order by tb.id
from @ta ta
select a,b,left(c,2)+ right('00000'+cast(cast(right(c,len(c)-2) as int)+1 as varchar),5)[c] from #表1
insert #表1 select 'aa ', 'aa00001 ', 'aa00100 ',100 select left(rtrim(C),2)+ right(cast(cast(right(rtrim(C),5) as int )+100001 as char(6)),5) from #表1drop table #表1
=========================
aa00101
create table #表1(A varchar(10),B varchar(50),C varchar(50),D int )
insert #表1 select 'aa ', 'aa00001 ', 'aa00100 ',100 select left(rtrim(C),2)+ right(cast(cast(right(rtrim(C),5) as int )+100001 as char(6)),5) from #表1 drop table #表1
=========================
aa00101