|
It is an often problem with
Article describes what is
This article shows how to
Many a time, you are
database intergration when
SQL? what it is used for?
generate random records from
confronted with creating a
you use a reserved word.
how to SELECT, INSERT,
the database. Also explains
system DSN for use with ASP.
Often asked why a script
UPDATE and DELETE records
how to generate random
If you have an ISP account,
does not work and it quite
from the database? and more.
numbers. Sample Database and
this might take time and
often comes down the the
Code available for download.
more than sometimes - money.
author setting a field name
This article describes how
as a reserved word,
to use File DSNs and save
confusing SQL and making
time and money. Also, you
debugging hard. To solve
can reuse these DSNs and
this problem here is a quick
thus, with some
list of the SQL Reserved
modifications, use the same
Words.
DSN for as many database
connections.
Date: Aug, 28 2003 Date: Mar, 13 2002 Date: Aug, 30 2000 Date: Jan, 25 2000 |
|
This article by James Shaw
Sometimes, we would have
Connections, Commands and
This article describes how to
demonstrates how to
chance to convert our
Procedures is a sample
use Microsoft SQL Server
dynamically add properties
existing database or create
chapter from Professional
triggers to automatically
to an object (expando
a new database. Some
Active Server Pages which
record all updates and
properties) - by
decisions IT professionals
discuss in depth all the
inserts for a particular
implementing a function to
need to make are scary, and
issues related with
database table in a
create named recordsets.
choosing database software
establishing connection to a
customized history table.
is one of them. This
database to the carrying out
overview aims to describe
of commands and procedures.
how to set database
connections with some common
database software (Oracle,
MySQL, MS Access,MS SQL
Server).
Date: Dec, 16 2000 Date: Sep, 01 2003 Date: Mar, 20 2000 Date: Sep, 20 2001 |