How to create and use server side cursors in SQL Server?

__________________
The OXYGEN
Delivers edgy, intelligent Technology to all...

a.Declaring a Cursor
This is Syntax of Declaring a Cursor
DECLARE cursor_name [INSENSITIVE] [SCROLL] CURSOR
FOR select_statement
[FOR {READ ONLY | UPDATE [OF column_name [,...n]]}]

or

DECLARE cursor_name CURSOR
[LOCAL | GLOBAL]
[FORWARD_ONLY | SCROLL]
[STATIC | KEYSET | DYNAMIC | FAST_FORWARD]
[READ_ONLY | SCROLL_LOCKS | OPTIMISTIC]
[TYPE_WARNING]
FOR select_statement
[FOR UPDATE [OF column_name [,...n]]]

b.Opening a Cursor
This is Syntax of Opening a Cursor
OPEN { { [GLOBAL] cursor_name } | cursor_variable_name}

c.Fetching a Cursor
This is Syntax of Fetching a Cursor
FETCH
[ [ NEXT | PRIOR | FIRST | LAST
| ABSOLUTE {n | @nvar}
| RELATIVE {n | @nvar}
]
FROM
]
{ { [GLOBAL] cursor_name } | @cursor_variable_name}
[INTO @variable_name[,...n] ]

d.Closing a Cursor
This is Syntax of Closing a Cursor
CLOSE { { [GLOBAL] cursor_name } | cursor_variable_name }

e.Deallocating a Cursor
This is Syntax of Deallocating a Cursor
DEALLOCATE { { [GLOBAL] cursor_name } | @cursor_variable_name}

Did u mean creating cursors on the Database server and will work on the events based on the database / server updations?

__________________
-Murali..