select cast(field_1 as varchar)+char(13)+char(10)+cast(field_2 as varchar)+char(13)+char(10)+cast(field_3 as varchar)+char(13)+char(10) from tablename
结果要用文本形式才能显示
create table #temp(field int)
go
insert #temp select field_1 from tablename
insert #temp select field_2 from tablename
insert #temp select field_3 from tablename
go
select * from #temp
drop table #temp