15.5.2 检查指定游标是否存在的函数.sql

sqlserver 数据库编程的绝好脚本

CREATE FUNCTION f_CursorExists(@CursorName sysname)
RETURNS TABLE
AS
RETURN(
	SELECT * FROM(
		SELECT Name=@CursorName,
			Type=CAST('LOCAL' as varchar(8)),
			IsExists=CAST(CASE CURSOR_STATUS('LOCAL',@CursorName)
				WHEN -3 THEN 0 ELSE 1 END as bit)
		UNION ALL
		SELECT @CursorName,'GLOBAL',
			CASE CURSOR_STATUS('GLOBAL',@CursorName) WHEN -3 THEN 0 ELSE 1 END
		UNION ALL
		SELECT @CursorName,'VARIABLE',
			CASE CURSOR_STATUS('VARIABLE',@CursorName) WHEN -3 THEN 0 ELSE 1 END
	)a WHERE IsExists=1)
GO