sql server 函数
godropfunction 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 FORselect aname FROM allhy where aid in (@dwhangye)
DECLARE mc CURSOR FORselect aname FROM allhy where @dwhangye like '%'+aid+'%'
OPEN mc
FETCH NEXT FROM mcINTO @onename
WHILE @@FETCH_STATUS = 0
BEGIN
set @allname=@allname+@onename+','
FETCH NEXT FROM mcINTO @onename
end
CLOSE mc
--关闭游标同时删除游标
DEALLOCATE mc
set @allname=substring(@allname,1,len(@allname)-1)
return @allname
END
go
select dbo.gethystr('#1#,#2#')
页:
[1]