sql server 行转 逗号分隔 字符串

 SELECT  
(STUFF((SELECT top 3 ',' + CAST(UserID AS NVARCHAR) FROM AccountsInfo  FOR  XML PATH('')  ),1,1,'')) UserID

 

 

 

 ALTER TABLE  表名  ADD CreateTimestamp ROWVERSION ;