We need you!

Members

Technology Zones

Articles

Hosted By

Info

• Index
• / Internet Programming
• / Active Server Pages
• / Database Development

Articles & Tutorials

• SQL Injection Attacks by Example

  by SJFriedl

  Steve Friedl takes a look at how your site could be vulnerable to SQL injection attacks - complete with numerous examples - and the action you can take to prevent them..

• Identifying Your New Records

  by LACanadian

  While the use of AutoNumber and Identity fields in tables is greatly applauded by database designers the world over, they can be annoying for developers to use. This article reveals two techniques for retrieving the value of an AutoNumber/Identity field..

• ADO and Unicode

  by davepamn

  How to use Microsoft ADO to add and update unicode code points stored in an Oracle UTF8 database. .

• Using SQL-DMO To Backup and Verify a Database

  by Carvin Wilson

  The SQL Distributed Management objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks using programming and scripting languages. This article shows you how to use SQL-DMO to create an Active Server Page application to backup and verify a SQL Server database. .

• SQL Distributed Management Objects Part 2

  by S.S. Ahmed

  Learn how to administer SQL Server remotely..

• More Database Development Articles & Tutorials...

Sample Code

• ADO Command and Stored Procedures

  by davepamn

  You can design stored procedures to hide such complexities, leaving a more concise interface available for application development. This demonstrates how to use the ADO Command object to call these SQL Stored Procedures..

• dbHitMe Site traffic logger

  by mrjdesign

  dbHit: A simple traffic logger I tossed together in the start of my ASP coding days. It simply collects data from your visitors and stores it in MS Access 97 mdb file..

• Paginate a recordset

  by James Crowley

  How to split up a recordset into multiple pages using ADO and ASP.

• Reuse ADO recordsets

  by ElementK Journals

  How to reuse ADO recordsets without destroying them first.

• How to include Text, nText and Image datatypes in a Union query

  by ElementK Journals

  How to include Text, nText and Image datatypes in a Union query.

• More Database Development Sample Code...

Sample Chapters

• Stored Procedures

  From Beginning Visual Basic SQL Server 7.0

  An introduction to Stored Procedures, from the book Beginning Visual Basic SQL Server 7..

Reviews

• Review of SQL Server 2000 Programming

  by James Crowley

  SQL Server 2000 Programming claims to be a comprehensive guide to SQL Server 2000, and at a hefty 1390 pages, you can't argue with that. Being a programming guide, it concentrates only on issues that affect an SQL Server developer, but it still covers topics such as Database Administration to a reasonable level..

Books

• Professional SQL Server 2000 Programming

  Published by Wrox Press

  Read the review of this extensive guide for all SQL Server 2000 developers.

• Beginning ASP Databases

  Published by Wrox Press

  ASP is Microsoft's glue technology for providing complex, interactive, data-driven web pages for both inter- and intra-nets. ASP runs on the Windows NT web server IIS. 1 million web sites are using....

Web Sites

• Utilizing ASP to Provide Online Database Access

  A brief example of the process of creating an ASP page to access database information and then display it properly on a webpage.

Search

Code Samples

New Members