select stuff((select ‘,‘+title from tb for xml path(‘‘)),1,1,‘‘)
substring(Floor,0,(len(Floor)-1)
cast(Floor as int )
SQL 拼接和转换
原文：http://www.cnblogs.com/2260827114com/p/7131116.html
