Implementation of the "SQL Server" dynamic cursor

Method 1:

CREATE TABLE #tabTmp (id int)
INSERT #tabTmp EXECUTE (' SELECT ID from ' [email protected])

DECLARE curone cursor FOR
SELECT ID from #tabTmp
Open Curone
FETCH NEXT from Curone to @ID

Method 2

EXEC ('
DECLARE curone cursor Global
For ' + @aSql)
Open Curone
Fetch Curone

Method 3:

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 ' [email protected] + ' from ' + @tablename
EXEC (@sql)
Open Cutemp
Fetch cutemp into @name
while (@ @fetch_status =0)
Begin
Print @name
Fetch cutemp into @name
End
Close Cutemp
Deallocate cutemp

Source: http://www.cnblogs.com/sekihin/archive/2007/05/11/742797.html

Implementation of the "SQL Server" dynamic cursor