/**

popular collection of scripts for all

*/
/** Search */

{ 

Database-related

 }

Using GetRows To Get All Records From Table

Hits: 1299
*****
3.0

Using Multiple Recordsets

Hits: 452
*****
4.0

Using MyODBC To Access Your MySQL Database Via ASP

Hits: 561
*****
0.0

Using SQL-DMO To Backup and Verify a Database

Hits: 570
*****
0.0
Following example, extracts
This article explains a
MySQL is the most popular
This article shows you how to
all of the records in a
solution on how to increase
open source database system
use SQL-DMO to create an
database table and stores
the performance of your ASP
available today, and is
Active Server Pages
into a 2-dimensional array.
pages that rely on gathering
currently installed on over
application to backup and
This gives you an advantages
data through several
two million servers
verify a SQL Server
to modify and work on data.
different Recordsets.
worldwide. This article
database. The SQL
 
Specially, using a nifty
takes a look at using the
Distributed Management
 
feature of the ADO Recordset
free MyODBC driver to talk
Objects (SQL-DMO) extend the
 
object, Multiple Recordsets,
to a MySQL database from an
functionality of SQL Server
 
you can store multiple SQL
ASP script.
by providing developers a
 
query results in one
 
way to execute common tasks.
 
Recordset object, requiring
 
 
 
fewer communications with
 
 
 
the database.
 
 


Date: Apr, 10 2004


Date: Sep, 05 2001


Date: Jan, 17 2002


Date: May, 29 2001
Sum function can be used for
This article describes how to
When faced with learning a
It is an often problem with
to get the sum of a numeric
use Microsoft SQL Server
new technology, it's common
database intergration when
expression evaluated over a
triggers to automatically
to try and reproduce the
you use a reserved word.
set. This function must be
record all updates and
basic functionality you're
Often asked why a script
placed in an SQL statement.
inserts for a particular
used to in the old one. In
does not work and it quite
Following example will
database table in a
doing that with ADO.NET and
often comes down the the
return the sum of ratings in
customized history table.
trying to reproduce the
author setting a field name
articles.
 
basics or the recordset
as a reserved word,
 
 
object, this article
confusing SQL and making
 
 
discusses the new and many
debugging hard. To solve
 
 
uses of ADO.NET's DataView
this problem here is a quick
 
 
object.
list of the SQL Reserved
 
 
 
Words.


Date: Apr, 01 2004


Date: Sep, 20 2001


Date: Aug, 27 2003


Date: Aug, 28 2003
{ Copyright } ©2019 NuclearScripts.com