|
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 |