游标里怎么执行字符拼出来的select串

游标里如何执行字符拼出来的select串

SQL code

    DECLARE @SQL VARCHAR(300)        SET @SQL = 'SELECT YXKHZD_KHMC FROM '+@TEMPTABLE    DECLARE    MY_CURSOR CURSOR FOR          EXEC(@SQL)        ......