SQL查询一列数据，结果为用特殊符号分割的一行数据

CREATE      PROCEDURE   [ dbo ] . [ get_string_id_and_name ]  
@strName   nvarchar ( 4000 ) output, 
@strid     nvarchar ( 4000 ) output
AS
select   @strName   =   ''
select   @strid   =   ''
select   @strName   =   @strName   +   COALESCE (ProductName  +   ' , ' ,  '   ' ),  @strPid   =   @strPid   +   COALESCE (ProductID  +   ' , ' ,  '   ' )
from  Product_Table 
order   by  ProductName

转载于:https://www.cnblogs.com/zhuhee/archive/2006/09/03/493908.html