Database Sample Code
-
ASP.NET Graphical Page Hit Counter
by Raam Kumar
Generate graphics on the fly to provide a graphical page hit counter, storing the counter in a text file or SQL database.
-
Access AutoNumber Reset
by Michael Gagne
This is some sample code that shows how to programmatically reset all AutoNumber fields in an Access Database to a correct value (whether it be 0 or the max value + 1). In addition, it contains code for Compacting and Repairing an MS Access Database. This is perfect for people who are working with a complicated Access Database and have experienced AutoNumber bugs!
-
Create Table in a Database
by amoibade
This code shows you how to create a table and it's indexes in a database at run time.
-
ActiveX Data Object Simple Routines
by Macky M
These groups of Procedures will allow you to Open Databases, Run SQL Statements, as Well as Execute Stored Procedures without hassle...
-
Display SQL Server table data in a browser
by Edward Tanguay
Just supply your database connection string and this code will give you a radio button list of all your SQL Server tables and will show their fields.
-
Form filter example
by Thamar
An example of filtering the data displayed in Microsoft Access Forms using VBA.
-
SQL Running Total
by Neil
One SELECT statement to calculate running total in Access OR MS-SQL (And anything else for that matter).
-
ADO Command and Stored Procedures
by David Nishimoto
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.
-
Update MSMQ from SQL
by Bruce Johnson
Describes how to post a message into MSMQ from within a SQL procedure
-
ColdFusion function demonstration
by Tim Garver
This complete page demonstrates several different Cold Fusion functions, from passing form variables to outputting database recordsets
-
Remote ODBC
by Crispin Wright
How to install ODBC connections remotely using the Registry API, connect to a network machine, and install users System DSN's without having to travel around sites.
-
Handling multiple Direct ODBC calls that fail.
by Dale Harkness
The article addresses the problem that sometimes occurs when making several direct ODBC calls in a sequence.
-
Deleting duplicate rows in a table
by Kevin Saitta
Eliminating duplicate rows of data from an Oracle database
-
Getting Started with Database Programming
by gigsv00
This is a conceptual idea of how I start to do database programming. In this article, I had highlighted a few points that become vital to understand for any new comers to do database programming.
-
T-SQL implementation of SKIPJACK
by David Janecka
A T-SQL implementation of the crypt algorith SKIPJACK as a user function for MS-SQL 2000
-
Database Schema using ADOX
by CodeWarrior
Print all the Table names and their respective Column names in whatever database you choose
-
Send an email using a ColdFusion form
by Julia Lynne Green
How to create a simple form, that posts to the page and emails a letter, and the results to everyone, including you.
-
Paginate a recordset
by James Crowley
How to split up a recordset into multiple pages using ADO and ASP
-
Limit the number of rows returned
by Alt-PHP-Faq
How to limit the number of records returned from a MySQL database
-
Running total in an SQL query
by James Crowley
How to create a running total column in an SQL query