/**

popular collection of scripts for all

*/
/** Search */

{ 

Database-related

 }

Filling Data into Select List

Hits: 2685
*****
4.0

Filtering and Sorting of Records in a Database

Hits: 925
*****
0.0

Fun With Stored Procedures...

Hits: 355
*****
1.0

Generating random records from the Database

Hits: 543
*****
0.0
In this short ASP source
Learn how to search and sort
This is a brief and very
This article shows how to
code, we will pull some data
the records through the
useful tutorial on creating
generate random records from
from a database and fill it
database. Step by step
and using stored procedures
the database. Also explains
into a select list. We will
tutorial with Sample code
with your asp applications.
how to generate random
create a custom and dynamic
and database available for
A stored procedure is
numbers. Sample Database and
output.
download. Online demo also
nothing more than an sql
Code available for download.
 
available.
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: Mar, 22 2006


Date: Jul, 10 2000


Date: Aug, 13 2000


Date: Aug, 30 2000
Learn how to get a stored
How do I get the Unique ID or
Storing frequently used
It is somewhat ironic that
image from a database and
Auto ID of the record I just
lookup data in a database is
the most confusing part of
display it on a page.
entered? The solution is
a great idea (e.g. order
creating and executing a SQL
 
really quite simple.
status codes, state names,
statement from ASP is
 
 
etc.) that saves tremendous
determining where to put the
 
 
amounts of time in design
quotes. When is a single
 
 
and maintenance. However,
quote used? When is a double
 
 
retrieving that data from
quote used? When are they
 
 
the database every time it
used together? Which takes
 
 
is needed is very
precedence? This article
 
 
inefficient. This article
will answer these questions.
 
 
describes how to use
 
 
 
Application variables to
 
 
 
cache frequently used lookup
 
 
 
data in memory to achieve
 
 
 
lightning fast access times.
 


Date: Jan, 03 2006


Date: Dec, 10 2002


Date: Jun, 28 2000


Date: Feb, 27 2001
{ Copyright } ©2019 NuclearScripts.com