/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

SQL Tutorial

Hits: 655
*****
0.0

SQL In Simple English - Part 1

Hits: 654
*****
0.0
SQL, Structured Query
It is an often problem with
Step-by-step tutorial on how
Article describes what is
Language, is the most
database intergration when
to display uploaded binary
SQL? what it is used for?
powerful tool to connect to
you use a reserved word.
files from the database
how to SELECT, INSERT,
a database regardless of the
Often asked why a script
using plain ASP pages. Every
UPDATE and DELETE records
form of the database.
does not work and it quite
step has been explained in
from the database? and more.
However, building a perfect
often comes down the the
detail. Downloadable source
 
SQL statement can be very
author setting a field name
code available.
 
frustrating. Especially
as a reserved word,
 
 
debugging -- the error
confusing SQL and making
 
 
message simply didn't tell
debugging hard. To solve
 
 
you where the error is. This
this problem here is a quick
 
 
tutorial provides a nice
list of the SQL Reserved
 
 
summary of SQL statements.
Words.
 
 


Date: Feb, 15 2000


Date: Aug, 28 2003


Date: Jun, 17 2002


Date: Mar, 13 2002
This article by James Shaw
You can connect to an Access
This article shows how to
Many a time, you are
demonstrates how to
database within an ASP page
generate random records from
confronted with creating a
dynamically add properties
with different methods. This
the database. Also explains
system DSN for use with ASP.
to an object (expando
article will help you to
how to generate random
If you have an ISP account,
properties) - by
create a System Data Source
numbers. Sample Database and
this might take time and
implementing a function to
Name (DSN) for an Access
Code available for download.
more than sometimes - money.
create named recordsets.
database on your local
 
This article describes how
 
machine.
 
to use File DSNs and save
 
 
 
time and money. Also, you
 
 
 
can reuse these DSNs and
 
 
 
thus, with some
 
 
 
modifications, use the same
 
 
 
DSN for as many database
 
 
 
connections.


Date: Dec, 16 2000


Date: Jun, 14 2000


Date: Aug, 30 2000


Date: Jan, 25 2000
{ Copyright } ©2019 NuclearScripts.com