Advertisment

Edit records with sql statements

Learn how to edit records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the...

Views: 870 | | by Brad
ASP - Database Related

Delete records with sql statements

Learn how to delete records with an SQL instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from...

Views: 994 | | by Troy
ASP - Database Related

Use an include file for your database connection

Use an include file for your database connection. Here's the reason why. Before I wised up to this, I was placing the connection on every...

Views: 838 | | by John
ASP - Database Related

Uploading and inserting files (binary data) to the database

Step-by-step tutorial on how to upload files (images, text, other documents, etc) using plain ASP pages to the database. Every step has been...

Views: 703 | | by Nick
ASP - Database Related

Displaying binary data from the database using plain ASP

Step-by-step tutorial on how to display uploaded binary files from the database using plain ASP pages. Every step has been explained in detail....

Views: 795 | | by Daniel
ASP - Database Related

SQL In Simple English - Part II

This is the second article in this series. This article mainly deals with SQL Joins and SQL sub-queries. Both of these are extremely useful SQL...

Views: 888 | | by Sean
ASP - Database Related

ASP upload to database or file

To database or not to database? Test of consumed resources (processor, memory) and results with file upload to database or file system. Test of...

Views: 724 | | by Nick
ASP - Database Related

Professional C# 2nd Edition : Data Access with .NET

Complete Online Chapter 'Data Access with .NET' from Wrox Press book 'Professional C# 2nd Edition'. Topics covered include...

Views: 0 | | by Mathew
ASP - Database Related

SQL In Simple English - Part 1

Article describes what is SQL? what it is used for? how to SELECT, INSERT, UPDATE and DELETE records from the database? and more.

Views: 673 | | by Steve
ASP - Database Related

Connecting to your SQL Database

If you have an SQL database set up with your web host, a useful tip to know is how to connect to your SQL database via Enterprise Manager. The...

Views: 690 | | by Source
ASP - Database Related

Compact & Repair Access Database

Compact and repair your access database online from ASP code. This is example code of how this can be done.

Views: 697 | | by Sarah
ASP - Database Related

Analyzing Duplicate Records

This is the first of the four-part 'Advanced SQL Techniques' series, which describes a quick and efficient way to delete duplicate...

Views: 658 | | by Stephen
ASP - Database Related

Using Triggers to Track Database Action History

This article describes how to use Microsoft SQL Server triggers to automatically record all updates and inserts for a particular database table in...

Views: 668 | | by David
ASP - Database Related

Randomizing a Recordset

This article describes several ways to use a SQL calculated field and the ORDER BY clause to arrange a recordset in random order. It provides a...

Views: 732 | | by Donald
ASP - Database Related

Using Multiple Recordsets

This article explains a solution on how to increase the performance of your ASP pages that rely on gathering data through several different...

Views: 665 | | by Marry
ASP - Database Related

Fastest way of Database Access : Caching Records in Memory

A step by step tutorial on caching data in memory. This tutorial goes one step further from simply caching data in memory to allow you to set a...

Views: 586 | | by Simon
ASP - Database Related

Using Disconnected Recordsets

This article covers rarely discussed feature of ADO Recordsets, disconnected Recordsets. It examines what disconnected Recordsets are, how to use...

Views: 652 | | by Simon
ASP - Database Related

Printing Headers on every page of a report (from a database)

The author writes 'Recently I was asked to develop a web based report that would collect data from a database, format it in an HTML page and...

Views: 652 | | by Nick
ASP - Database Related

Interrogating a Stored Procedure with ADO

This article describes how to use the refresh method of the ADO Parameters collection to interrogate a stored procedure. It shows how to create the...

Views: 684 | | by Jarry
ASP - Database Related

SQLServerTools Object

This example shows how to get a list of all current tables in the database, get a list of dependent stored procedures for each table and do it all...

Views: 625 | | by Steve
ASP - Database Related