SQL Sample Code
-
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
-
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
-
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
-
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
-
Data-shaped SQL clauses
by ElementK Journals
How to build a data-shaped SQL clause for VB
-
Auto Form
by Santi Mondejar
Automatically generate a HTML form from an SQL query
-
Plan for debugging
by ElementK Journals
A few tips on planning in advance debugging in your ASP pages
-
Access, VB and SQL Server wildcard characters
by James Crowley
Important differences between Access, VB and SQL Server wildcard characters