SQL Server将数据库中多行中的某个字段转换为字符串

   
将表名为TableName字段为Name的字段的值拼接起来，返回结果name1,name2,name...

CREATE   FUNCTION  convertMultiRowsToChar( @id   int )  RETURNS   varchar ( 50 ) 
AS   BEGIN   DECLARE   @sql   varchar ( 50 )
SET   @sql   =   ''
           SELECT   @sql   =   @sql   +   ' , '   +   cast (Name  AS   varchar )
         FROM  TableName
         WHERE  Id  =   @id   RETURN   stuff ( @sql ,  1 ,  1 ,  '' )  END

转载于:https://www.cnblogs.com/seamanhy/archive/2007/07/27/833826.html