SQL server implements a cursor with Parameters

From: http://lwlzyjl.cnblogs.com/
Method 1:

Create Table # tabtmp (id int)
Insert # tabtmp execute ('select ID from '+ @ tablename)

Declare curone cursor
Select ID from # tabtmp
Open curone
Fetch next from curone into @ ID

Method 2:

Exec ('
Declare curone cursor global
For '+ @ asql );
Declare @ STR nvarchar (20 );
Open curone
Fetch curone into @ STR;
While (@ fetch_status = 0)
Begin
...
Fetch curone into @ STR;
End;
Close curone;
Deallocate curone;

In contrast, Oracle is much more intuitive to use.
Cursor c_get_f_name
(
Id int
)
Is
Select f_id, f_name
From f_info
Where (f_id in (
Select f_id
From a_dot
Where (a_id = ID )));