笔记283 游标中如何实现 动态SQL 2013-6-8

笔记283 游标中如何实现 动态SQL 2013-6-8

--游标中如何实现 动态SQL 2013-6-8
USE [GPOSDB]
GO
DECLARE @cmd NVARCHAR(MAX)
DECLARE @index INT
SET @index=1
IF ( 1 = 1 )
    BEGIN
        SET @cmd = 'select * from dbo.CT_InhouseCard where I_IC_CardType='+CAST(@index AS NVARCHAR(100))
    END
ELSE
    BEGIN
        SET @cmd = 'select * from dbo.CT_InhouseCard where I_IC_CardType='+CAST(@index AS NVARCHAR(100))
    END
DECLARE @cur CURSOR
DECLARE @sql NVARCHAR(MAX)
SET @sql = N'SET @cur = CURSOR FOR ' + @cmd + N'; OPEN @cur;';
EXEC sp_executesql @sql, N'@cur CURSOR OUTPUT', @cur OUTPUT;
FETCH @cur;
CLOSE @cur;