/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

SQL Tutorial

Hits: 734
*****
0.0

SQL In Simple English - Part 1

Hits: 732
*****
0.0

File DSNs - Use and Reuse

Hits: 729
*****
0.0
SQL, Structured Query
Article describes what is
This article shows how to
Many a time, you are
Language, is the most
SQL? what it is used for?
generate random records from
confronted with creating a
powerful tool to connect to
how to SELECT, INSERT,
the database. Also explains
system DSN for use with ASP.
a database regardless of the
UPDATE and DELETE records
how to generate random
If you have an ISP account,
form of the database.
from the database? and more.
numbers. Sample Database and
this might take time and
However, building a perfect
 
Code available for download.
more than sometimes - money.
SQL statement can be very
 
 
This article describes how
frustrating. Especially
 
 
to use File DSNs and save
debugging -- the error
 
 
time and money. Also, you
message simply didn't tell
 
 
can reuse these DSNs and
you where the error is. This
 
 
thus, with some
tutorial provides a nice
 
 
modifications, use the same
summary of SQL statements.
 
 
DSN for as many database
 
 
 
connections.


Date: Feb, 15 2000


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
{ Copyright } ©2019 NuclearScripts.com