/**

popular collection of scripts for all

*/
/** Search */

{ 

Database-related

 }

SQL In Simple English - Part 1

Hits: 750
*****
0.0

Generating random records from the Database

Hits: 746
*****
0.0

SQL Tutorial

Hits: 746
*****
0.0

Named Recordsets

Hits: 744
*****
0.0
Article describes what is
This article shows how to
SQL, Structured Query
This article by James Shaw
SQL? what it is used for?
generate random records from
Language, is the most
demonstrates how to
how to SELECT, INSERT,
the database. Also explains
powerful tool to connect to
dynamically add properties
UPDATE and DELETE records
how to generate random
a database regardless of the
to an object (expando
from the database? and more.
numbers. Sample Database and
form of the database.
properties) - by
 
Code available for download.
However, building a perfect
implementing a function to
 
 
SQL statement can be very
create named recordsets.
 
 
frustrating. Especially
 
 
 
debugging -- the error
 
 
 
message simply didn't tell
 
 
 
you where the error is. This
 
 
 
tutorial provides a nice
 
 
 
summary of SQL statements.
 


Date: Mar, 13 2002


Date: Aug, 30 2000


Date: Feb, 15 2000


Date: Dec, 16 2000
Many a time, you are
Sometimes, we would have
This article describes how to
Connections, Commands and
confronted with creating a
chance to convert our
use Microsoft SQL Server
Procedures is a sample
system DSN for use with ASP.
existing database or create
triggers to automatically
chapter from Professional
If you have an ISP account,
a new database. Some
record all updates and
Active Server Pages which
this might take time and
decisions IT professionals
inserts for a particular
discuss in depth all the
more than sometimes - money.
need to make are scary, and
database table in a
issues related with
This article describes how
choosing database software
customized history table.
establishing connection to a
to use File DSNs and save
is one of them. This
 
database to the carrying out
time and money. Also, you
overview aims to describe
 
of commands and procedures.
can reuse these DSNs and
how to set database
 
 
thus, with some
connections with some common
 
 
modifications, use the same
database software (Oracle,
 
 
DSN for as many database
MySQL, MS Access,MS SQL
 
 
connections.
Server).
 
 


Date: Jan, 25 2000


Date: Sep, 01 2003


Date: Sep, 20 2001


Date: Mar, 20 2000
{ Copyright } ©2019 NuclearScripts.com