/**

popular collection of scripts for all

*/
/** Search */

Calling Stored Procedures In Asp

 }

Fun With Stored Procedures...

Hits: 15
*****
1.0
This is a brief and very
 
 
 
useful tutorial on creating
 
 
 
and using stored procedures
 
 
 
with your asp applications.
 
 
 
A stored procedure is
 
 
 
nothing more than an sql
 
 
 
statement stored inside a
 
 
 
database. The database can
 
 
 
be SQL Server or MS Access
 
 
 
as well as others. A stored
 
 
 
procedure is compiled by
 
 
 
your database (for the most
 
 
 
part) one time, when it is
 
 
 
entered. This results in
 
 
 
faster database executions
 
 
 
and overall performance
 
 
 
updates, and it further
 
 
 
separates the sql statement
 
 
 
from your asp leaving you
 
 
 
with more readable code.
 
 
 
This tutorial describes:
 
 
 
What is a stored procedure?,
 
 
 
Writing stored procedures,
 
 
 
Getting the stored procedure
 
 
 
into the database,
 
 
 
Calling stored procedures
 
 
 
in ASP pages, and
 
 
 
Modifying and removing
 
 
 
stored procedures.
 
 
 


Date: Aug, 13 2000
{ Copyright } ©2006 NuclearScripts.com