→ how to call stored procedures sprocs from jscript
There’s not much -or useful- information about how to call Stored Procedures (SPROCS) using jscript. Therefore, this is the very very basic way to do it. I will just explain what the following script is doing.
First things first… the regular jscript function name declaration followed by a “try…catch…finally Statement” where I’m setting up the connection string. One of the hardest parts from using ADO is getting the connection string right. You can get this Information from the developer of the project you’re working on, or look at http://www.connectionstrings.com.
For more detailed information and more advanced examples, this guy wrote an excellent “how-to” using parameters for a more advanced SPROC.
http://andrewu.co.uk/clj/stored_procedures_with_jscript/ blog comments powered by Disqus