好東西∼如何將SQL子查詢的多筆結果放到同一個欄位

請把這行放到子查詢後面吧： FOR XML PATH('')

例句：

SELECT
*,(select [ChName]+',' from user_data where [id] <> '' FOR XML PATH('')) as EXp2
FROM [TABLE]

 

 --

看到、想到、說到、做到　
能夠填平大海的誓言，也比不上邁出一步的價值　
是以吾輩此生，再無任何誓言

SE Hazel J20 - 小花模式拍大花

DSC00009.JPG
Originally uploaded by Antarcticat.

感覺還不錯！清晰度、色彩、景深

協作平台試用！

這次為了程式開發人員可共同編輯文件，試著拿出好久沒上去的「Google協作平台」！除了不能線上編輯文件外(你不會去用Google文件喔！)，感覺還不錯。剛好適合這個專案使用，還可以設幾個倒數計時器嚇自己！

--
看到、想到、說到、做到　
能夠填平大海的誓言，也比不上邁出一步的價值　
是以吾輩此生，再無任何誓言

看到想到-公文常用名詞中英對照

檔號 File No.
保存年限 Years of Storage
函 Official Letter
正本受文者 Original to
副本受文者 Copy to
發文日期 Issue Date
發文字號 Issue No.
速別 Level of Urgency
密等及解密條件或保密期限 Confidentiality Class & Release Condition or Confidentiality Period
附件 Attachment, Supplement
隨函 enclosed
主旨 Subject
說明 Explanation

--
看到、想到、說到、做到　
能夠填平大海的誓言，也比不上邁出一步的價值　
是以吾輩此生，再無任何誓言

看到想到-Important Notes files to save or backup

Important Notes files to save or backup
The following is a list of Notes files that you may want to save or backup in case you ever need to uninstall Notes and then reinstall it at another time. Note You may not have all of these files.

File name	Location	Comments
BOOKMARK.NSF	Notes\Data directory	Contains your saved bookmarks and Welcome Page information.
BUSYTIME.NSF	Notes\Data directory	Contains your local free time information.
DESKTOP6.NDK	Notes\Data directory	This is your Workspace that maps to your bookmarks.
HEADLINE.NSF	Notes\Data directory	Contains your Database Subscriptions information.
INSTALL.LOG	Notes program directory	Contains the configuration information based on the options available when you install Notes. This file is used for comparison when you upgrade to new versions of Notes.
INTERNET.NSF	Notes\Data directory	Contains information from your newsgroup subscriptions (NNTP).
NAMES.NSF	Notes\Data directory	Contains your contacts, connections, locations, and Personal Address Book information.
NOTES.INI	Notes program directory	Contains the information you provide when you set up Notes, including the options you select in User Preferences. May also contain information created by your administrator. This file gets deleted when you uninstall Notes.
PERWEB.NSF	Notes\Data directory	This is your Personal Web Navigator database that contains Web browser information.
USER.DIC	Notes\Data directory	Contains all of the words you have added to your personal dictionary through the "Add to Dictionary" option in the Spell Checker.
*.NSF	Notes\Data directory	Local databases that you create are stored in the Data directory.
<yourname>.NSF (local copy)	Notes\Data directory	Contains your Mail, Calendar, and To Do list. This only shows up in the Data directory if you have a local replica of your Mail file.
<yourname>.ID	Notes\Data directory	This is your User ID file. You need this to access Notes.

--
看到、想到、說到、做到　
能夠填平大海的誓言，也比不上邁出一步的價值　
是以吾輩此生，再無任何誓言