https://blog.youkuaiyun.com/nGx11zh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/nGx11/article/details/5701413https://blog.youkuaiyun.com/nGx11/article/details/5701413nGx11Tue, 29 Jun 2010 11:46:00 +0800本文出处： http://nft01.nuk.edu.tw/lib/e-news/20060801/3-2.htm
 
2.1 XQuery Expressions
　　一個XQuery 的敘述式為一組FLWOR (發音同 “flower”) 表示法，是由For、Let、Where、Order by及Return子句等結構而成，並以特定的順序組合而成如圖2-2所示。

 
圖2-2　FLWOR表示法之資料結構順序
  　　FO]]>https://blog.youkuaiyun.com/nGx11/article/details/5701358https://blog.youkuaiyun.com/nGx11/article/details/5701358nGx11Tue, 29 Jun 2010 11:25:00 +0800STUFF 函数将字符串插入另一字符串

--字符串"xyz"置于字符表达式"abc"的第二个字符处，并总共替换三个字符。
SELECT STUFF('abcefg', 3,3, 'xyz')
 
--把查询的数据生成XML数据select ContainerKey from MC_Container for xml path
Result:

  A2010062400013<]]>https://blog.youkuaiyun.com/nGx11/article/details/4184213https://blog.youkuaiyun.com/nGx11/article/details/4184213nGx11Thu, 14 May 2009 17:26:00 +0800https://blog.youkuaiyun.com/nGx11/article/details/4184184https://blog.youkuaiyun.com/nGx11/article/details/4184184nGx11Thu, 14 May 2009 17:23:00 +0800https://blog.youkuaiyun.com/nGx11/article/details/4072759https://blog.youkuaiyun.com/nGx11/article/details/4072759nGx11Tue, 14 Apr 2009 14:22:00 +0800https://blog.youkuaiyun.com/nGx11/article/details/4072662https://blog.youkuaiyun.com/nGx11/article/details/4072662nGx11Tue, 14 Apr 2009 13:55:00 +0800https://blog.youkuaiyun.com/nGx11/article/details/4069699https://blog.youkuaiyun.com/nGx11/article/details/4069699nGx11Mon, 13 Apr 2009 16:13:00 +0800