/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

SQL In Simple English - Part II

Hits: 823
*****
0.0

Suggestion Box

Hits: 818
*****
0.0
This is the second article in
Sample implementation (source
This is an article about
You can connect to an Access
this series. This article
code)illustrating how to
displaying binary data
database within an ASP page
mainly deals with SQL Joins
implement a "Suggestion
(images) from an Access
with different methods. This
and SQL sub-queries. Both of
Box" style form using
database. Online demo and
article will help you to
these are extremely useful
ASP and MS Access. Easily
sample code available for
create a System Data Source
SQL constructs and should be
installed, and customized.
download.
Name (DSN) for an Access
learnt by all beginners.
 
 
database on your local
 
 
 
machine.


Date: May, 10 2002


Date: Mar, 20 2006


Date: Apr, 03 2001


Date: Jun, 14 2000
Article describes what is
It is an often problem with
Step-by-step tutorial on how
This article shows how to
SQL? what it is used for?
database intergration when
to display uploaded binary
generate random records from
how to SELECT, INSERT,
you use a reserved word.
files from the database
the database. Also explains
UPDATE and DELETE records
Often asked why a script
using plain ASP pages. Every
how to generate random
from the database? and more.
does not work and it quite
step has been explained in
numbers. Sample Database and
 
often comes down the the
detail. Downloadable source
Code available for download.
 
author setting a field name
code available.
 
 
as a reserved word,
 
 
 
confusing SQL and making
 
 
 
debugging hard. To solve
 
 
 
this problem here is a quick
 
 
 
list of the SQL Reserved
 
 
 
Words.
 
 


Date: Mar, 13 2002


Date: Aug, 28 2003


Date: Jun, 17 2002


Date: Aug, 30 2000
{ Copyright } ©2019 NuclearScripts.com