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
连接列:
select
cast(col1 as varchar(100)) + 分隔符
cast(col2 as varchar(100)) + 分隔符
--------------------------------------
cast(coln as varchar(100)) as 一列
from yourtable where ...