Cursor for dynamically executed SQL strings

• visbek

  SSC-Addicted

  Points: 430

  More actions

  February 13, 2004 at 3:31 am

  #178208

  You can dynamically execute a sql string in a stored procedure:

  SET @SQL = 'SELECT * FROM table'

  EXEC (@SQL)

  Is it possible to declare a cursor for a dynmaically executed SQL string?

  eg:

  SET @SQL = 'SELECT field FROM table'

  DECLARE cursorTest CURSOR FOR

        @SQL

  or something like that because the above doesn't work 😉

   

• jeremy amos

  SSC Rookie

  Points: 27

  More actions

  February 13, 2004 at 9:45 am

  #494026

  no but you could do

  @sql = 'select * from table'

  @cursor = 'DECLARE cursorTest CURSOR FOR '

  exec(@cursor + @sql)