SQL Server之XML PATH()

DECLARE @MedicalInstitutionID NVARCHAR(100)='SYS20130228000000012';
SELECT  ',' + MedicineTypeID
FROM    Dic_Res_StoreToType b
WHERE   b.MedicalInstitutionID = @MedicalInstitutionID
FOR     XML PATH('')

posted @   轴轴  阅读(228)  评论(0编辑  收藏  举报
点击右上角即可分享
微信分享提示