小程序:扫一扫查出行【扫一扫了解最新限行尾号】复制小程序 SELECT CAST(OrderID AS varchar)+',' as OrderNo
FROM Product
CAST函数用于将某种数据类型的表达式显式转换为另一种数据类型
SELECT CAST(OrderID AS varchar)+','
FROM Product FOR XML PATH('')
转成标准xml
SELECT CAST(OrderID ) as 'MyOrder'
FROM Product FOR XML PATH('Order')