Database-related

Database-related. Tutorials & Tips. ASP. Scripts from Hot Scripts. Review before you use or buy a script! Let Hot Scripts uncover the best free, open source and commercial hot-scripts Database-related scripts for your web site.

Results 61 - 80 of 130

« 1 2 3 4 5 6 7 »
More Options
  • This article will show you two different methods that you can use to connect to a Microsoft SQL Server 2000 database: System DSN's and the OLEDB connection string. It will also explain the positives and negatives of each method, along with some examples

    ... (show more)
    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • This is the first of the four-part "Advanced SQL Techniques" series, which describes a quick and efficient way to delete duplicate records from a table.

    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • This article describes how to use Microsoft SQL Server triggers to automatically record all updates and inserts for a particular database table in a customized history table.

    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • 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 simple tool for verifying that the results are uniformly random. Also shows a technique for bubbling records

    ... (show more)
    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • This article explains a solution on how to increase the performance of your ASP pages that rely on gathering data through several different Recordsets. Specially, using a nifty feature of the ADO Recordset object, Multiple Recordsets, you can store

    ... (show more)
    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • 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 time limit in seconds after which it refreshes the data in memory. Extremely useful technique. Online demo

    ... (show more)
    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • This article covers rarely discussed feature of ADO Recordsets, disconnected Recordsets. It examines what disconnected Recordsets are, how to use them, and what advantages they offer over connected Recordsets. Also examines how to create custom,

    ... (show more)
    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • 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.

    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • 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.

    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • 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.

    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • 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.

    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • 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

    ... (show more)
    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • 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

    ... (show more)
    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • 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 ready

    ... (show more)
    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • 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 boxes." This tutorial explains how

    ... (show more)
    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • 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.

    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • This is an example code showing how to conduct searches on a database to display hyperlinked summaries that can be clicked on to display detail data.

    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • This article presents three modular routines to access and fetch data easier with ASP. Topics include: Fetching a Recordset, An alternative to the GetConnectedRecordSet function that opens a connection, fetches a recordset, and immediately closes the

    ... (show more)
    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • A discussion of how to use null values effectively in your database tables. Includes a discussion of the logic behind nulls and some practical programming techniques.

    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
  • This is a sample code that combines a Database Paging and a Database Search script into one. It shows you how to perform a wilcard search on a database table and then page through the results.

    Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose

Results 61 - 80 of 130

« 1 2 3 4 5 6 7 »