SQL Server cursor demo

1 -- Create a cursor
2 Declare Curuser Cursor   For  
3 Select   Top   30 Email From Dbuser
4 Where Hasdone = 0
5
6 Open Curuser
7
8 Declare   @ Emailaddr   Varchar ( 200 )
9 Fetch   Next   From Curuser Into   @ Emailaddr
10
11 While ( @ Fetch_status = 0 )
12 Begin
13 Print   @ Emailaddr
14 Fetch   Next   From Curuser Into   @ Emailaddr
15 End  
16
17 -- Close cursor
18 Close Curuser
19 Deallocate Curuser
20