STOREDPROCEDURES_JSCRIPT.ASP

<% @ LANGUAGE="JScript" %> 

<!--#include file="adojavas.inc"-->

<%
// This example calls the ByRoyalty stored procedure
// installed with the PUBS database with Microsoft SQL Server.

// This sample assumes that SQL Server is running on the local machine
%>


<HTML>
<HEAD>
<TITLE>Using Stored Procedures</TITLE>
</HEAD>

<BODY bgcolor="white" topmargin="10" leftmargin="10">

<!-- Display Header -->

<font size="4" face="Arial, Helvetica">
<b>Using Stored Procedures</b></font><p>

<%
var oConn;
var oCmd;
var oRs;

oConn = Server.CreateObject("ADODB.Connection");
oCmd = Server.CreateObject("ADODB.Command");


// Open ADO Connection using account "sa"
// and blank password

oConn.Open("DSN=LocalServer;UID=sa;PWD=;DATABASE=pubs");
oCmd.ActiveConnection = oConn;


// Setup Call to Stored Procedure and append parameters

oCmd.CommandText = "{call byroyalty(?)}";
oCmd.Parameters.Append(oCmd.CreateParameter("@Percentage", adInteger, adParamInput));


// Assign value to input parameter

oCmd("@Percentage") = 75;


// Fire the Stored Proc and assign resulting recordset
// to our previously created object variable

oRs = oCmd.Execute();
%>

Author ID = <% Response.Write(oRs("au_id")) %><BR>

</BODY>
</HTML>