sql查询语句，输出的结果中如何换行？谢谢！

[kk706]

如：
select 'result' + name from userTable where id = 1;

想要的结果如下：
result
Liying

请问如何输出result后，换行显示Liying。谢谢！

[liangCK]

SELECT 'result'+CHAR(13)+name FROM userTable WHERE  id=1;

[Andy__Huang]

declare @s varchar(100)
set @s=''
select @s='result'+char(10)+ name from userTable where id = 1
print @s

[Andy__Huang]

declare @s varchar(100)
set @s=''
select @s='result'+char(10)+ name from userTable where id = 1
print @s

[dpzc_love]

SELECT NAME AS RESULT FROM USERTABLE WHERE ID = 1

[肥龙上天]

[Quote=引用楼主 kk706 的帖子:]
如：
select 'result' + name from userTable where id = 1;

想要的结果如下：
result
Liying

请问如何输出result后，换行显示Liying。谢谢！
[/Quote]

select result = [name]
from usrTable
where id = 1

[Zoezs]

SELECT 'result'+CHAR(13)+name FROM userTable WHERE  id=1;

[i95890347]

学习一下 多谢