类似sum()函数,将聚合的值按照字符串连接方式连接起来.
CREATE FUNCTION [dbo].[strlink] ( @fuji nvarchar(20) ) RETURNS nvarchar(100) AS begin DECLARE MyCURSOR CURSOR FOR SELECT distinct 国家 FROM dbo.SalesList where 区域=@fuji declare @quyu varchar(50) declare @guojia varchar(50) set @guojia = '' open MyCURSOR fetch next from MyCURSOR into @quyu while(@@fetch_status=0) begin set @guojia=@guojia+@quyu+', ' fetch next from MyCURSOR into @quyu end close MyCURSOR return @guojia end