如题:
表A里只有一个字段,且里面的内容无规律:
A
a01
-------------
aa
34
b1
现定义一个字符串str
用循环怎样得到str="aa,34,b1"?
------解决方案--------------------
- SQL code
declare @str varchar(20)set @str=''select @[email protected]+','+LTRIM(a01) from Aselect RIGHT(@str,LEN(@str)-1) as new
------解决方案--------------------
- SQL code
declare @A table (a01 varchar(32))insert @a select 'aa' union all select '34' union all select 'b1'declare @str varchar(20)set @str=''select @[email protected]+','+LTRIM(a01) from @Aselect RIGHT(@str,LEN(@str)-1) as new/*newaa,34,b1*/