select stuff(( select '--'+subject from test for xml path('')),1,1,'') as UserNamestr 说明:test --表名,subject--列名