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. vb.net, .net, ado.net, sql

• 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. sql, sql server

• 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. asp.net, sql, sql server

• How to access a MySQL database with .NET

  by Edward Tanguay

  Demonstrates how to connect to a MySQL database with C#. asp.net, vb.net, ado.net, mysql

• Databinding SqlTypes

  by Dan Glass

  Demonstrates how Databind the SqlTypes using the PropertyDescriptor class and the ITypedList Interface. c#, asp.net, sql

• 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. c#, ado.net, sql

• 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. php, mysql, sql

• 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. asp.net, sql, sql server

• SQL Running Total

  by neilc

  One SELECT statement to calculate running total in Access OR MS-SQL (And anything else for that matter). sql

• Update MSMQ from SQL

  by Bruce Johnson

  Describes how to post a message into MSMQ from within a SQL procedure sql server, sql

• Deleting duplicate rows in a table

  by Kevin Saitta

  Eliminating duplicate rows of data from an Oracle database sql, oracle

• 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 sql server, sql

• Running total in an SQL query

  by James Crowley

  How to create a running total column in an SQL query sql

• 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 sql

• Access, VB and SQL Server wildcard characters

  by James Crowley

  Important differences between Access, VB and SQL Server wildcard characters sql, sql server

• Data-shaped SQL clauses

  by ElementK Journals

  How to build a data-shaped SQL clause for VB visual basic, sql