这样子的SQL语句要怎么写？

[liujingbo911]

我想在一个文本框中显示我从SQL中查到的数据如ID，NAME。我想在显示的时候是这样子的。“1｜小明”。请问select ID,NAME from student这个语句间还要放置什么吗？

[cansum396]

select CAST(ID AS NVARCHAR(50))+'|'+NAME from student

[cpp2017]

select cast(id as varchar(10)) +'|'+ name from student

[lizhizhe2000]

SELECT ID+'|'+[name] FROM users

[My97]

楼上是对的

[lazyfish]

textbox.Text=string.Format("{0}|{1}",ID,Name)

[helblazer]

select ID+"|"+NAME as txt from student
?