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 ASP Speed Tricks This article describes practical methods of optimizing the performance of ASP pages which retrieve and display tabular data from a database. Test results of each coding technique show the potential for dramatic speedups of dynamic web pages. Suggestion Box Sample implementation (source code)illustrating how to implement a "Suggestion Box" style form using ASP and MS Access. Easily installed, and customized. Using Stored Procedures A stored procedure is like a map to commonly requested information, which can speed things up. This is because stored procedures are cached in the server. Using GetRows To Get All Records From Table Following example, extracts all of the records in a database table and stores into a 2-dimensional array. This gives you an advantages to modify and work on data. Uploading Images to Database Using Persist AspUpload You can upload your images to MS-SQL server with this simple script. To upload a picture to sql database, be sure Persist AspUpoad installed in you server. How to Get Identity of New Record Sometimes you need the learn new record number while your are adding a new record. Following example adds a new records to a table and gets the the autonumber or identity of that records. Using SUM Function in An SQL Statement Sum function can be used for to get the sum of a numeric expression evaluated over a set. This function must be placed in an SQL statement. Following example will return the sum of ratings in articles. Compacting an Access database from ASP code This source code can compact and repair your MS-Access database files. If you compact your access files regularly, it will work more faster and secure. Also you will save some hard disk space. Executing Transact-SQL UPDATE statement In this example, we will edit some records from a database. This source code helps us to edit records to database without slowing down database Executing Transact-SQL INSERT statement In this example, we will add some records to a database. This source code helps us to adding records to database without slowing down database.

Google Search