一个简单的SQL语句，大家来看看！

[evilks]

table1(s1,s2,s3,s4,s5,s6,s7)现在我要把s1到s6的数据取出来显示为一列，该怎么做？

[txlicenhe]

Select cast(s1 as varchar) + ' ' +
cast(s2 as varchar) + ' ' +
cast(s3 as varchar) + ' ' +
cast(s4 as varchar) + ' ' +
cast(s5 as varchar) + ' ' +
cast(s6 as varchar) as 一列 from table1

[pengdali]

Select cast(s1 as varchar(100)) + ',' +
cast(s2 as varchar(100)) + ',' +
cast(s3 as varchar(100)) + ',' +
cast(s4 as varchar(100)) + ',' +
cast(s5 as varchar(100)) + ',' +
cast(s6 as varchar(100)) 一列 from table1

[friendliu]

Select cast(s1 as varchar(100)) + ',' +
cast(s2 as varchar(100)) + ',' +
cast(s3 as varchar(100)) + ',' +
cast(s4 as varchar(100)) + ',' +
cast(s5 as varchar(100)) + ',' +
cast(s6 as varchar(100)) newcolname from table1

[gmlxf]

连接列：
select
cast(col1 as varchar(100)) + 分隔符
cast(col2 as varchar(100)) + 分隔符
--------------------------------------
cast(coln as varchar(100)) as 一列
from yourtable where ...

[evilks]

查出来了，但是他是横着排的，能不能让他竖下来。。

[CrazyFor]

竖下来是什么意思?

[evilks]

现在的结果是
a
12 34 45 56
我想
a
12
34
45
56

[youngby]

declare @s1 varchar(20),
declare @s2 varchar(20),
declare @s3 varchar(20),
declare @s4 varchar(20),
declare @s5 varchar(20)

select @s1=sl,@s2=s2,@s3=s3,@s4=s4.@s5=s5,@s6=s6
from table

iINSERT INTO T1 (s7)
VALUES (@s1)
INSERT INTO T1 (s7)
VALUES (@s2)
.....


.....

[evilks]

up

[cloudchen]

select s1 from table1
union all
select s2 from table1
union all
select s3 from table1
union all
select s4 from table1
union all
select s5 from table1
union all
select s6 from table1
union all
select s7 from table1

[king0401]

同意楼上的

[welyngj]

必须以文本形式显示。
select cast(s1 as varchar) +char(13)+char(10)+cast(s2 as varchar)+char(13)+char(10)+cast(s3 as varchar)+..... from b

[evilks]

谢谢，，问题解决了。。