Library code snippets tagged with sql
-
SQL Data Provider VB.NET Class
by
This class includes some useful methods for working with Misrosoft SQL Server in .NET simply and quickly.
-
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.
-
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.
-
How to access a MySQL database with .NET
by Edward Tanguay
Demonstrates how to connect to a MySQL database with C#.
-
Databinding SqlTypes
by Dan Glass
Demonstrates how Databind the SqlTypes using the PropertyDescriptor class and the ITypedList Interface.
-
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.
-
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.
-
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.
-
SQL Running Total
by neilc
One SELECT statement to calculate running total in Access OR MS-SQL (And anything else for that matter).
-
Update MSMQ from SQL
by Bruce Johnson
Describes how to post a message into MSMQ from within a SQL procedure
-
Deleting duplicate rows in a table
by Kevin Saitta
Eliminating duplicate rows of data from an Oracle database
-
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
-
Running total in an SQL query
by James Crowley
How to create a running total column in an SQL query
-
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
-
Access, VB and SQL Server wildcard characters
by James Crowley
Important differences between Access, VB and SQL Server wildcard characters
-
Data-shaped SQL clauses
by ElementK Journals
How to build a data-shaped SQL clause for VB