/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

SQL In Simple English - Part 1

Hits: 535
*****
0.0
Step-by-step tutorial on how
This article covers two
Article describes what is
Connections, Commands and
to display uploaded binary
advanced ADO topics:
SQL? what it is used for?
Procedures is a sample
files from the database
creating hierarchical
how to SELECT, INSERT,
chapter from Professional
using plain ASP pages. Every
Recordsets (via data
UPDATE and DELETE records
Active Server Pages which
step has been explained in
shaping) and creating custom
from the database? and more.
discuss in depth all the
detail. Downloadable source
Recordsets. Specifically,
 
issues related with
code available.
this article looks at how to
 
establishing connection to a
 
create custom hierarchical
 
database to the carrying out
 
Recordsets. The reader is
 
of commands and procedures.
 
required to have a fluid
 
 
 
understanding of both data
 
 
 
shaping and custom
 
 
 
Recordsets.
 
 


Date: Jun, 17 2002


Date: Jun, 05 2001


Date: Mar, 13 2002


Date: Mar, 20 2000
Many a time, you are
You all must have seen and
This article describes how to
Sometimes, we would have
confronted with creating a
done stuff with the
use Microsoft SQL Server
chance to convert our
system DSN for use with ASP.
RecordSet object, infact
triggers to automatically
existing database or create
If you have an ISP account,
everything is done with the
record all updates and
a new database. Some
this might take time and
RecordSet object. Now, this
inserts for a particular
decisions IT professionals
more than sometimes - money.
acticle explains how to use
database table in a
need to make are scary, and
This article describes how
GetRows to page through the
customized history table.
choosing database software
to use File DSNs and save
records that you recieve
 
is one of them. This
time and money. Also, you
from the SELECT. It's much
 
overview aims to describe
can reuse these DSNs and
faster than MoveNext,
 
how to set database
thus, with some
because it closes the
 
connections with some common
modifications, use the same
database connection
 
database software (Oracle,
DSN for as many database
immediately whereas MoveNext
 
MySQL, MS Access,MS SQL
connections.
loops through the records
 
Server).
 
with the overhead of the
 
 
 
database connection. Plus
 
 
 
GetRows let's you count the
 
 
 
records correctly!
 
 


Date: Jan, 25 2000


Date: Oct, 04 2003


Date: Sep, 20 2001


Date: Sep, 01 2003
{ Copyright } ©2019 NuclearScripts.com