|
Analyzing Duplicate Records
|
Other links at ASP > Tutorials > Database-related |
| 1. |
Using SQL-DMO To Backup and Verify a Database
|
|
|
This article shows you how to use SQL-DMO to create an Active Server Pages application to backup and verify a SQL Server database. The SQL Distributed Management Objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks.
|
| 2. |
Access Connection DSN-Less Code
|
|
|
So you need a DSN-Less connection but your not quite sure what to do. Well we can do this for you. A quick and easy way to make a connection without a DSN. This will work for your MS Access database only. Now includes SQL Server.
|
| 4. |
Dynamically Generated HTML Forms
|
|
|
This article discusses two different ways to dynamically generate data-entry forms: Use the ADO OpenSchema Method, and Query Your SQL Server System Tables. Describes advantages and disadvantages of each method.
|
| 5. |
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 info from a form. Both examples include an example of a DSN-LESS connection.
|
|
|
