如题:
ID productname
--------------------------------
1 'a'
1 'b'
1 'c'
结果:
ID productName
--------------------------------
1 'a,b,c'
CREATE function [dbo].[f_productName](@c varchar(200), @d varchar(200))
returns varchar(100)
as
begin
declare @b varchar(200)
set @b=''
select @b=@b+ProductName+',' from v_OutCustoms where CLPNo=@c and HSCode = @d
if len(@b) > 1
set @b=left(@b,len(@b)-1)
return(@b)
end
转载于:https://www.cnblogs.com/JohnXIe/archive/2008/03/20/1114833.html