SQL, database, informix, oracle, SQL Servercontest, prize, free, money, cash, prizes, software
Quick Search for:  in language:    
SQL, database, informix, oracle, SQL Server,contest, prize, free, money, cash, prizes, software
   Code/Articles ╗ |  Newest/Best ╗ |  Community ╗ |  Jobs ╗ |  Other ╗ |  Goto ╗ | 
CategoriesSearch Newest CodeCoding ContestCode of the DayAsk A ProJobsUpload
SQL Stats

 Code: 28,860 lines
 Jobs: 418 postings

 
Sponsored by:

 

You are in:

 
Login



Latest Code Ticker for SQL.
how to apply a filter to an Access 2000 form by using a combo box as a filter parameter
By David Nishimoto on 8/16


DBCC Log
By Keith Henry on 8/6


Metaphone
By Keith Henry on 8/6


StripTel
By Keith Henry on 8/6


sp_CatchProcess es
By Keith Henry on 8/6


dbo.DoubleMetaP hone
By Keith Henry on 8/5


Click here to put this ticker on your site!


Add this ticker to your desktop!


Daily Code Email
To join the 'Code of the Day' Mailing List click here!





Affiliate Sites



 
 
All-Time Hall of Fame
Back to contest home

July 2002
Contest Winners and Superior Code

Procedure to Export/Import Images In/From SQL SERVER
the procedure is used as an Interface to the TextCopy Utility supplied with SQL SERVER in order to simplify handling of BLOBS (images/docs)
 
 
 
 
June 2002
Contest Winners and Superior Code

pl/sql mega tutorial
This is a great 50 pages notes/tutorials on pl/sql blocks, exception handling, procedures, functions, triggers, packages....
 
SQL In Simple English - Part II
This article mainly deals with SQL Joins and SQL subqueries. Both of these are extremely useful SQL constructs and should be learnt by all beginners.
 
May 2002
Contest Winners and Superior Code

Tedious queries 150
These are the worlds most tedious queries....all r solved. If you solve these queries then u will become the master of sql...
 
 
 
 
April 2002
Contest Winners and Superior Code

SQL In Simple English - Part 1
Great article on how to do SQL-written in plain English.
 
User Defined Function Intro
Brief introduction to user defined functions with examples and benefits explained.
 
March 2002
Contest Winners and Superior Code

Find a string in Procedures, Triggers, Constraints, Defaults, Functions, and Views
Allow users to search thru objects for a value they are looking. This may be items that touch a specific table/view or items that need to be replaced.
 
Join the results of a stored procedure in T-SQL : A Clean Sample
There may be several instances where you have to join the results of a stored procedure with another query. Here's how to do it
 
January 2002
Contest Winners and Superior Code

nth largest/smallest from a table
To find Nth largest and Smallest 'value'(Numbers) from a Table.
 
 
 
 
December 2001
Contest Winners and Superior Code

Read a text file into SQL SERVER
Using BULK INSERT TO READ A TEXT FILE into SQL SERVER and ELIMINATING THE USE of another text editor.
 
Using Case Statements to Empower your Betweens
To demonstrate selection queries using Case statements to adjust bewtween clauses range based on situational needs.
 
November 2001
Contest Winners and Superior Code

Format integer strings (Function & SP)
Formats a string representing a numeric or decimal value, to an input length of 6000 characters and adds commas after every set of three numbers.
 
 
 
 
October 2001
Contest Winners and Superior Code

Convert to Julian date
Convert to Julian date and Convert From Julian Date Functions
 
 
 
 
August 2001
Contest Winners and Superior Code

Pivot Data based on Unknown Field Items
Pivot data on a column without knowing exactly what values exist.
 
 
 
 
July 2001
Contest Winners and Superior Code

Spaces Used
Space Used : This script gives you all the space used by each table
 
 
 
 
June 2001
Contest Winners and Superior Code

Use XML as a stored procedure parameter in SQL 2000!
How to simply pass the XML code itself as an ntext parameter, and just load it in as though it were a recordset.
 
 
 
 
May 2001
Contest Winners and Superior Code

Insert Procedure Generator
Produce an "insert" procedure with full transaction and error handling by simply passing a table name to the procedure.
 
 
 
 
April 2001
Contest Winners and Superior Code

Backup All Databases
Backup all databases on your server automatically with this script!
 
More Efficient Queries using Vitual Tables!!
Reduce your query times exponentially by using virual tables!
 
March 2001
Contest Winners and Superior Code

RandomBetween
How to generate random numbers within a given range.
 
Script your data
This procedure generates INSERT statements using existing data from given tables that you can use to transfer the data elsewhere. Check it out!
 
spObjectPermissions
Handy stored procedure to query object permissions for specified user.
 
 
 
 
February 2001
Contest Winners and Superior Code

Discovering a table size
This procedure helps you calculate table sizes, so you can better plan the database size.
 
sp_GrantPermissions
Grants Select, Insert, Update, Delete, and Execute permissions to all stored procedures and user defined tables and views.
 
January 2001
Contest Winners and Superior Code

OpenRowSet w/Parameters
Steps to use parameters with the OPENROWSET function. Check it out!
 
sp_sessBCP
Bulk Copy(BCP) data out of one or all tables from a specified database and specified server to one or all tables in a database on the same or different server.
 
December 2000
Contest Winners and Superior Code

Deeply Nested INNER joins
An example of how to handle the sometimes confusing nested INNER joins.
 
FindDupes
Learn how to detect duplicate rows in a table and provide a count of the dupes.
 
November 2000
Contest Winners and Superior Code

Creating XML in a Stored Procedure
Use a cursor in a stored procedure to create short XML string to output rather than recordsets
 
 
 
 
September 2000
Contest Winners and Superior Code

Connect SQL Server 7.0 to Informix
Informix and SQL Server can play nicely with each other if you know how. This tutorial shows you the way.
 
Find Column Name On SQL Server Tables
Handy code to locate that hard to find column name
 
August 2000
Contest Winners and Superior Code

Array-like Manipulation
SQL is set oriented so programmers often have a hard time duplicating tried and true procedural algorithims. Heres some help.
 
Correlated Query Example
If you're new to SQL, correlated queries can make you scratch your head. This example eases you through it.
 
Oracle Database Standards Part 2
Serious databases require serious standards--part 2 of this 3 part tutorial gives some great tips!
 
Oracle Password Info
Everything you ever wanted to know about Oracle passwords.
 
Progress Indicator on Stored Procs
Shows a technique for returning progress completed info on a long run SP.
 
SQL Server Backup Strategy
If you wait until you lose data before you read this, you may be too late! Learn how to make the recovery process an easy one!
 
Stored Proceudre Tutorial
Create your first stored procedure with ease using this well written and easy to follow tutorial.
 
 
 
 



 

Categories | Articles and Tutorials | Advanced Search | Recommended Reading | Upload | Newest Code | Code of the Month | Code of the Day | All Time Hall of Fame | Coding Contest | Search for a job | Post a Job | Ask a Pro Discussion Forum | Live Chat | Feedback | Customize | SQL Home | Site Home | Other Sites | About the Site | Feedback | Link to the Site | Awards | Advertising | Privacy

Copyrightę 1997 by Exhedra Solutions, Inc. All Rights Reserved.  By using this site you agree to its Terms and Conditions.  Planet Source Code (tm) and the phrase "Dream It. Code It" (tm) are trademarks of Exhedra Solutions, Inc.