Free eBook - Interview Questions: Get over 1,000 Interview Questions in an eBook for free when you join JobsAssist. Just click on the button below to join JobsAssist and you will immediately receive the Free eBook with thousands of Interview Questions in an ebook when you join.

• Free Tutorials - HTML, Java, SQL, PHP, ASP, Perl, SQL Tutorials
• Discuss Programming Problems and Freshers Jobs related issues here.
• Discuss Final Year Project Ideas here.

Script Name Compact & Repair Access Database Compact and repair your access database online from ASP code. This is example code of how this can be done. Using MyODBC To Access Your MySQL Database Via ASP MySQL is the most popular open source database system available today, and is currently installed on over two million servers worldwide. This article takes a look at using the free MyODBC driver to talk to a MySQL database from an ASP script. Two Ways To Connect To SQL Server 2000 Via ASP 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 to get you started. Grabbing Data On The Fly When we’re querying a database, we will usually need to press a submit button on a form to pass data to another ASP page, which would generate the query, and return the results. In some situations, this page refresh is just plain annoying and takes too long to complete. This article will describe another way to query a database using a combination of web technologies. 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 records from a table. 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 a customized history table. 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 simple tool for verifying that the results are uniformly random. Also shows a technique for bubbling records with certain attributes to the top of an otherwise randomized list. ASP Access Database Tutorials This is a group of 3 tutorials that guide you through the process of using an MS Access Database in ASP. The tutorials teach you how to connect to a database, add data to the database, update the database, and delete from the database. The 3 tutorials togather allow you to build a simple Guestbook for your web site. 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 Recordsets. Specially, using a nifty feature of the ADO Recordset object, Multiple Recordsets, you can store multiple SQL query results in one Recordset object, requiring fewer communications with the database. 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 time limit in seconds after which it refreshes the data in memory. Extremely useful technique. Online demo available.

Google Search