sql server 函数

go
drop  function gethystr
go
CREATE    FUNCTION gethystr(@dwhangye nvarchar(1000) )
RETURNS   varchar(2000) 
AS
BEGIN

  	declare @allname nvarchar(1000),@onename varchar(20)
	--set @allname=@dwhangye;
  	--return @dwhangye
	set @allname='';
	--DECLARE mc CURSOR FOR  select aname FROM allhy where aid in (@dwhangye)
	DECLARE mc CURSOR FOR  select aname FROM allhy where @dwhangye like '%'+aid+'%'
	OPEN mc

	 FETCH NEXT FROM mc  INTO @onename
	 
	WHILE @@FETCH_STATUS = 0
		BEGIN
			set @allname=@allname+@onename+','
			FETCH NEXT FROM mc  INTO @onename
			 
		end
	 

	CLOSE mc
	--关闭游标同时删除游标  
	DEALLOCATE mc
	
	set @allname=substring(@allname,1,len(@allname)-1)
 
	return @allname
END
go

select dbo.gethystr('#1#,#2#')