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 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. Turn foreign keys into list boxes 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 to turn those foreign keys into list boxes automatically. What's in an ADO Connection String? 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. Name Search & Hyperlinks to Detail 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. Display Table Script Writer 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 to be displayed on the web. The DSN connection requires that you register the DSN for the db prior to executing the code. Add New Data Access Routines to Your Arsenal 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 connection, and Utilities for Creating Valid SQL Statements. Null Is Null 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. Database Paged Search 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. Integrating User Search with ASP and SQL Server Full-Text Search This article provides sample source code for a user query parser which allows users to submit full-text search queries from ASP to SQL Server 2000. Full source code available for download. SQL: Sum, Average, Max, Min, Count, Detail This example shows how to perform a variety of statistics on your data using simple SQL such as Sum, Average, Max, Min, and Count. It uses stock trading performance of EPOS as an example.

Google Search