Parameters and SQL Server stored functions
 
To call stored procedures or functions with parameters in ADO the following syntax can be used:
 
{ ? = call myfunction( ? ) }
 
Make a new command and assign this SQL.  
Then add the parameters to the command.
 
Source:
How to call SQL Server stored procedures from ASP
http://support.microsoft.com/kb/164485