- 1,251 categories
- 40,829 scripts
- 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 then print a certain number of rows on each page with a column header on each page. This solution s...
- 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 code in an automated fashion for use in VBScript connecting to MS SQL Server 7.
- 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 in a stored procedure.
- AddCriteria is a small function that simplifies the code needed to produce a SQL query from a set of optional criteria posted by a user. This article explains how to use this function.
- This is a quick sample code which combines a number of database functions into one script. Includes functions to add, delete, and edit records in a database table. It illustrates a number of useful techniques for database manipulation.
- This article covers two advanced ADO topics: creating hierarchical Recordsets (via data shaping) and creating custom Recordsets. Specifically, this article looks at how to create custom hierarchical Recordsets. The reader is required to have a fluid ...
- 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 t...
- The author writes &"CoverYourASP''s original database administration tool didn''t look for foreign keys, and just displayed a confusing list of primary key values. Now, it''s been improved with automatically generated list box...
- This article explains ADO connection strings and parameters. By the end of the article you should be able to build appropriate ones on your own instead of cutting and pasting them.
- This is a Web-based script writer that generates an ASP code for displaying an Access or SQL Server database using user-submitted variable names and the name of the table. Copy the output code into an asp document on your web server and your db is re...
Page: