[Original] use dynamic SQL statements when defining a cursor

When defining a cursor, we sometimes need to use dynamic SQL statements. The following examples show errors and correct statements.

Incorrect syntax:

Code
Declare   @ SQL   Nvarchar ( 4000 )
Declare   @ I   Int = 1
While   @ I < 10
Begin
Set   @ SQL = ' Select * from # TMP where sortid = ' + @ I
Set   @ I = @ I + 1
Declare T_cur Cursor   For   Exec   @ SQL
Open T_cur

End

Correct syntax:

Code
Declare   @ SQL   Nvarchar ( 4000 )
Declare   @ I   Int = 1
While   @ I < 10
Begin
Set   @ SQL = ' Declare t_cur cursor for select * from # TMP where sortid = ' + @ I
Set   @ I = @ I + 1
Exec   @ SQL
Open T_cur

End

 

In this way, we should be able to figure out why by comparing the two methods.