SQL Sample Code
-
Deleting duplicate rows in a table
by Kevin Saitta
Eliminating duplicate rows of data from an Oracle database
-
How to access a MySQL database with .NET
by Edward Tanguay
Demonstrates how to connect to a MySQL database with C#.
-
"On Error Resume Next" considered harmful
by Palo Mraz
Discusses some unexpected implications of using the 'On Error Resume Next' statement in Visual Basic applications.
-
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.
-
How to delete records with SqlCommand
by Edward Tanguay
This code shows you how to delete records with an SQL statement and get the number of records deleted returned back as an integer.
-
Running total in an SQL query
by James Crowley
How to create a running total column in an SQL query
-
Get metadata on MySQL databases
by Edward Tanguay
An example of how to get metadata - such as all the databases on the server, all of their tables, and the corresponding field information for that table.
-
Debug ASP.NET pages using Tracing
by Julian Roberts
Demonstrates a useful debugging technique taking advantage of traces in ASP.NET.
-
Limit the number of rows returned
by Alt-PHP-Faq
How to limit the number of records returned from a MySQL database
-
Resizing images retrieved from SQL server
by Simon Soanes
A neat way of fetching an image stored in SQL Server and resizing it before save/sending it anywhere.
-
Access, VB and SQL Server wildcard characters
by James Crowley
Important differences between Access, VB and SQL Server wildcard characters
-
How to run through multiple DataReader results
by Edward Tanguay
You can save code by piling SQL statements into one SqlCommand and then getting a DataReader with multiple result sets.
-
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
-
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.
-
Update MSMQ from SQL
by Bruce Johnson
Describes how to post a message into MSMQ from within a SQL procedure
-
ADO Utility Class
by NeverMalchik
ADO class containing useful functions - counting records, creating database from scratch, openning/closing database, filling listbox/combo box with an sql statements, manipulating records....and much more.
-
Transactions made easy with .NET 2.0
by Xavier Larrea
One of the more significant improvement in .NET 2.0 is the transactions area. Now with a single line it becomes extremely easy to support transactional code blocks using the concept of “ambient” transaction thanks to TransactionScope in the System.Transactions namespace.
-
SQL Data Provider VB.NET Class
by
This class includes some useful methods for working with Misrosoft SQL Server in .NET simply and quickly.
-
RSS Feed Helper Class
by James Crowley
A simple helper class to make generating an RSS feed a piece of cake - its the one we use on Developer Fusion too!
-
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.