sqlserver 函数游标

来源：互联网发布：vue.js window.open 编辑：程序博客网时间：2024/04/28 12:33

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 ONGOSET QUOTED_IDENTIFIER ONGOALTER 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

0 0