/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

SQL In Simple English - Part 1

Hits: 780
*****
0.0

Named Recordsets

Hits: 778
*****
0.0
Article describes what is
This article by James Shaw
This article shows how to
Sometimes, we would have
SQL? what it is used for?
demonstrates how to
generate random records from
chance to convert our
how to SELECT, INSERT,
dynamically add properties
the database. Also explains
existing database or create
UPDATE and DELETE records
to an object (expando
how to generate random
a new database. Some
from the database? and more.
properties) - by
numbers. Sample Database and
decisions IT professionals
 
implementing a function to
Code available for download.
need to make are scary, and
 
create named recordsets.
 
choosing database software
 
 
 
is one of them. This
 
 
 
overview aims to describe
 
 
 
how to set database
 
 
 
connections with some common
 
 
 
database software (Oracle,
 
 
 
MySQL, MS Access,MS SQL
 
 
 
Server).


Date: Mar, 13 2002


Date: Dec, 16 2000


Date: Aug, 30 2000


Date: Sep, 01 2003
SQL, Structured Query
Many a time, you are
This article describes how to
Connections, Commands and
Language, is the most
confronted with creating a
use Microsoft SQL Server
Procedures is a sample
powerful tool to connect to
system DSN for use with ASP.
triggers to automatically
chapter from Professional
a database regardless of the
If you have an ISP account,
record all updates and
Active Server Pages which
form of the database.
this might take time and
inserts for a particular
discuss in depth all the
However, building a perfect
more than sometimes - money.
database table in a
issues related with
SQL statement can be very
This article describes how
customized history table.
establishing connection to a
frustrating. Especially
to use File DSNs and save
 
database to the carrying out
debugging -- the error
time and money. Also, you
 
of commands and procedures.
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: Jan, 25 2000


Date: Sep, 20 2001


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