/**

popular collection of scripts for all

*/
/** Search */

{ 

Database-related

 }

SQL Reserved Words

Hits: 17
*****
0.0

SQL In Simple English - Part II

Hits: 17
*****
0.0

Access Connection DSN-Less Code

Hits: 17
*****
0.0

SQL In Simple English - Part 1

Hits: 17
*****
0.0
Many times people will make
This is the second article in
So you need a DSN-Less
Article describes what is
the mistake of naming a
this series. This article
connection but your not
SQL? what it is used for?
database field with an SQL
mainly deals with SQL Joins
quite sure what to do. Well
how to SELECT, INSERT,
Reserved word. This is an
and SQL sub-queries. Both of
we can do this for you. A
UPDATE and DELETE records
easy mistake to make. It's
these are extremely useful
quick and easy way to make a
from the database? and more.
hard to remember every
SQL constructs and should be
connection without a DSN.
 
single one. Here's a concise
learnt by all beginners.
This will work for your MS
 
listing of SQL Reserved
 
Access database only. Now
 
words to help you along.
 
includes SQL Server.
 


Date: Jun, 17 2002


Date: May, 10 2002


Date: Apr, 15 2002


Date: Mar, 13 2002
This is a brief and very
This is a set of ASP
Active Server Pages allow us
This tutorial helps you to
useful tutorial on creating
examples/tutorials that
an easy means of querying
understand: Connecting ASP
and using stored procedures
demonstrate exactly how to
and updating a database from
Pages to MS Access Databases
with your asp applications.
use ASP with a database.
a webpage. This article
Persisting Data to MS
A stored procedure is
Topics include: Using ADO To
describes the basics of
Access Databases Protecting
nothing more than an sql
Add A New Record, Using ADO
using this technique in a
Data in SQL Statements
statement stored inside a
To Update An Existing
nutshell. The examples given
 
database. The database can
Record, Using An Update
here utilize a Microsoft
 
be SQL Server or MS Access
Query To Modify An Existing
Access database, but the
 
as well as others. A stored
Record, Using Delete
principles elucidated apply
 
procedure is compiled by
Statement to Delete Records,
equally well to ASP
 
your database (for the most
Using A Select Statement
integration with other
 
part) one time, when it is
(With A Loop), and ACCESS
databaes.
 
entered. This results in
DATABASES ( DSN vs DSN-LESS).
 
 
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


Date: Feb, 14 2000


Date: Jan, 25 2000


Date: Sep, 06 2006
{ Copyright } ©2006 NuclearScripts.com