sqlserver 通过函数传递一个值 去数据库查询数据付给其他的变量返回
其中用到了游标
<pre name="code" class="sql">USE [XM]
GO
/****** Object: UserDefinedFunction [dbo].[FUN_NEW_TYPE1] Script Date: 07/08/2014 15:33:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[FUN_NEW_TYPE1](@orgId varchar(max))
RETURNS varchar(max)
AS
BEGIN
DECLARE
@Result varchar(2000),
@temp varchar(6);
set @Result='';
DECLARE
func_cur CURSOR FOR
SELECT DISTINCT t.SERVICE_NEW_TYPE1
FROM dbo.OMP_SERVICE AS t
WHERE
t.ORG_ID = @orgId AND
t.AUDIT_STATUS = '3' AND
t.IF_DEL = '1'
OPEN func_cur
FETCH next from func_cur
INTO @temp
while @@FETCH_STATUS = 0
BEGIN
SET @Result = @Result + @temp + ','
FETCH next from func_cur
INTO @temp
END
CLOSE func_cur
DEALLOCATE func_cur
SET @RESULT = rtrim(@RESULT)
RETURN @Result;
END