Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Parameters and SQL Server stored functions (Read 2158 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Parameters and SQL Server stored functions
02.01.10 at 13:04:52
 
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
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1