SQL Server Sample Code
-
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.
-
Running total in an SQL query
by James Crowley
How to create a running total column in an SQL query
-
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
-
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.
-
Calculate Diskspace Used by a Table or Database
by James Crowley
This short snippet shows how to discover how large a particular table or an entire database is in SQL Server.
-
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
-
Paginate a recordset
by James Crowley
How to split up a recordset into multiple pages using ADO and ASP
-
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.
-
Randomly Sorting Records
by James Crowley
Here's now to randomly sort records in SQL Server 2000 - so you can potentially select say 10 random items from a table.
-
Health Monitoring in ASP.NET 2
by
This is a code sample for using health monitoring...
-
Bulk Insert from Flat File Using Transact-SQL
by M M Harinath
Importing Data from Text File using Transact-SQL is not a tough task, we can import data from Flat File in just 3 steps.