T-SQL Cursor Question

[Jorgandr]

Is there a way to use a variable in the select_statement part of the DECLARE CURSOR?

For instance I would like to do the following

SELECT @SQL = 'SELECT [' + @FieldName + '] FROM [QueryName]'

DECLARE CURSOR_1 CURSOR FOR @SQL

However this does not seem to work. Is there any way to do this? Any help would be greatly appreciated. Thank you.

 

[SQLSister]

First using dynamic SQl is a bad idea (This is what you are asking to do) and second do not use a cursor! If you are doing an insert, update or delete a cursor is easily turned into a set-based command that is both easier to read and maintain and way faster (sometimes hours can convert to seconds or even milliseconds)



"NOTHING is more important in a database than integrity." ESquared