/**

popular collection of scripts for all

*/
/** Search */

{ 

Database-related

 }

SQL In Simple English - Part 1

Hits: 765
*****
0.0

Generating random records from the Database

Hits: 763
*****
0.0

SQL Tutorial

Hits: 763
*****
0.0

File DSNs - Use and Reuse

Hits: 762
*****
0.0
Article describes what is
This article shows how to
SQL, Structured Query
Many a time, you are
SQL? what it is used for?
generate random records from
Language, is the most
confronted with creating a
how to SELECT, INSERT,
the database. Also explains
powerful tool to connect to
system DSN for use with ASP.
UPDATE and DELETE records
how to generate random
a database regardless of the
If you have an ISP account,
from the database? and more.
numbers. Sample Database and
form of the database.
this might take time and
 
Code available for download.
However, building a perfect
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: Mar, 13 2002


Date: Aug, 30 2000


Date: Feb, 15 2000


Date: Jan, 25 2000
Sometimes, we would have
This article by James Shaw
This article describes how to
Connections, Commands and
chance to convert our
demonstrates how to
use Microsoft SQL Server
Procedures is a sample
existing database or create
dynamically add properties
triggers to automatically
chapter from Professional
a new database. Some
to an object (expando
record all updates and
Active Server Pages which
decisions IT professionals
properties) - by
inserts for a particular
discuss in depth all the
need to make are scary, and
implementing a function to
database table in a
issues related with
choosing database software
create named recordsets.
customized history table.
establishing connection to a
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: Sep, 01 2003


Date: Dec, 16 2000


Date: Sep, 20 2001


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