首页 > 数据库技术 > 详细

SQL SERVER FOR XML PATH合并字符串

时间:2016-01-11 18:07:47      阅读:216      评论:0      收藏:0      [点我收藏+]

两种方式,效率立竿见影

------------------------------------------------
SET STATISTICS TIME ON
DECLARE  @OrderStr  NVARCHAR(max) = ‘‘;

SELECT @OrderStr += a.SerialNumber+,
FROM dbo.WithdrawalsLog a

SET STATISTICS TIME OFF
------------------------------------------------

SET STATISTICS TIME ON

DECLARE  @OrderStr  NVARCHAR(max) = ‘‘;

SET @OrderStr = (
SELECT a.SerialNumber+,
FROM dbo.WithdrawalsLog a
FOR XML PATH(‘‘)
)

SET STATISTICS TIME OFF
------------------------------------------------

 

如果要获取某个表的字段,并把它拼接成一个字符串,那这个方法再好不过了:

SELECT bankcode+,+bankname+;   FROM BankInfo FOR XML PATH(‘‘)

 

 

懒得写了,看不懂的看这里: 

http://www.cnblogs.com/doubleliang/archive/2011/07/06/2098775.html

 

SQL SERVER FOR XML PATH合并字符串

原文:http://www.cnblogs.com/DBArtist/p/FORXML.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!