连接同一字段的所有内容
create procedure PRO_CONNECT
@SCD_NO varchar(32),
@GY_TYPE_ID int
as
declare @gy_request varchar(1000)
set @gy_request=''
select @gy_request=case
when GY_REQUEST is not null then @gy_request+','+GY_REQUEST
end
from SH_SC_TASK_T
where
scd_no=@SCD_NO
and GY_TYPE_ID=@SCD_NO
select names = @gy_request
GO