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#')