Hi, there.

There is a sample code:
http://support.microsoft.com/support...&SA=ALLKB&FR=0

If you have SQL Server, then go to Enterprise Manager->Databases -> Pubs -> Objects -> Stored Procedures.
Open any of the sp and you will see the syntax for writing sp.

Larisa