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).
-
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.
-
Database Schema using ADOX
by CodeWarrior
Print all the Table names and their respective Column names in whatever database you choose
-
Reuse ADO recordsets
by ElementK Journals
How to reuse ADO recordsets without destroying them first
-
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
-
Data-shaped SQL clauses
by ElementK Journals
How to build a data-shaped SQL clause for VB
-
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.
-
Databinding SqlTypes
by Dan Glass
Demonstrates how Databind the SqlTypes using the PropertyDescriptor class and the ITypedList Interface.
-
Auto Form
by Santi Mondejar
Automatically generate a HTML form from an SQL query
-
ASP.NET Graphical Page Hit Counter
by Raam Kumar
Generate graphics on the fly to provide a graphical page hit counter, storing the counter in a text file or SQL database.
-
ActiveX Data Object Simple Routines
by Macky M
These groups of Procedures will allow you to Open Databases, Run SQL Statements, as Well as Execute Stored Procedures without hassle...
-
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.
-
Using ASHX files to retrieve DB images
by Harry Pierson
Learn how to use the little-known Http Handler functionality of ASP.NET to serve images from a database.
-
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.
-
Plan for debugging
by ElementK Journals
A few tips on planning in advance debugging in your ASP pages