Three methods for implementing SQL Server dynamic cursors

 

Code
Method 1:

Create Table # Tabtmp (ID Int )
Insert # Tabtmp Execute (' Select ID From ' + @ Tablename )

Declare Curone Cursor For
Select ID From # Tabtmp
Open Curone
Fetch Next From Curone Into @ ID

Method 2 for implementing sqlserver Dynamic Cursor:
Exec('
DeclareCuroneCursorGlobal
For'+ @ Asql)
OpenCurone
FetchCurone

Method 3 for implementing sqlserver Dynamic Cursor:
Declare @ SQL Varchar ( 2000 ),
@ Typefield Varchar ( 100 ),
@ Tablename Varchar ( 255 ),
@ Name Varchar ( 100 )
Select @ Typefield = ''Name '', @ Tablename = ''Sysobjects''
Set @ SQL = '' Declare Cutemp Cursor For ''
+ '' Select Distinct '' + @ Typefield + '' From '' + @ Tablename
Exec ( @ SQL )
Open Cutemp
Fetch Cutemp Into @ Name
While ( @ Fetch_status = 0 )
Begin
Print @ Name
Fetch Cutemp Into @ Name
End
Close Cutemp [ Page ]
Deallocate Cutemp