SQL, database, informix, oracle, SQL Server
Quick Search for:  in language:    
SQL, database, informix, oracle, SQL Server,source code, code, sample, samples, program, programs, help, tutorial,tutorials, routine, routines, jobs, listserve, mailinglist, bulletin board, bulletin boards, programming,  snippet, snippets, control, controls, class, classes, module, script, Scripts, applet , email , mp3, reference, windows,  modules, file, files, subroutine, subroutines, function, functions, sub, Microsoft, Sun,  downloads, winapi, directx, msaccess, ocx, vbx, ado, dao, odbc, rdo,  vbscript, vba, game programming, dcom, ole, com, dna, jet, dll, win api, winapi,  dbgrid, database front end, certify, decompiling, decompiler, visual basic for applications,  variable, constants, data type, byte, boolean, integer, long, single,  double, currency, date, object, string, variant, sub, function, free,
   Code/Articles  |  Newest/Best  |  Community  |  Jobs  |  Other  |  Goto  | 
CategoriesSearch Newest CodeCoding ContestCode of the DayAsk A ProJobsUpload
SQL Stats

 Code: 44,501. lines
 Jobs: 110. postings

 How to support the site

Sponsored by:

You are in:

Does your code think in ink?

Latest Code Ticker for SQL
By Ewald Hofman on 11/19

find depended objects
By chandra sekhar on 11/19

Is Num
By Jonathan Spinks on 11/14

Changing object owner to dbo
By Mike J Anderson on 11/9

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

What is SQL?

     SQL (Structured Query Language) is a language for retrieving information out of relational databases such as Oracle, Informix, SQL Server, Access and MySQL.

See all SQL Categories of Code

Please visit our sponsor
Planet Source Code
World News and Announcements
RapTier Code Generator!

Great new prize!
Harness the power of this easy to use multi-tier code generator and generator code in flash! Up to 5 lucky winners each month can choose this great prize! So submit early and submit often!
.Zip files now contain URL of posting!

Zip file improvements!
Don't you hate it when you download multiple .zip files, find one that is great, and want to post feedback or a vote on it, but can't remember which one it was? Well no longer! Now all .zip files have a special Planet Source Read Me text file that will take you right back to the submissions's page. So check it out!
Modulus Financial Engineering donates 2 financial programming packages as prizes!

Many thanks to Modulus Financial Engineer for their donation of Stock ChartX and TA-SDK for the contest Click here to check them out. As usual...submit early and often to get a shot at one of these two prizes!
Sams Publishing donates 6 great programming books as prizes!

6 Great Programming Book Prizes!
Many thanks to Sams Publishing who has donated six fantastic programming books on .NET, Perl and PHP programming. Click here to check them out. Remember to submit early and often to win one of these great prizes!
New contest prize: Smart Editor Professional

New Prize: Smart Editor Pro!
Monthly winners can choose this great Development Environment that allows you to program in a WYSIWYG editor, in a variety of programming languages (including C#, XML, HTML, Perl, Java, PHP, SQL, C/C++, Basic variants and more..)! It also provides an array of usefull features like custom languages, Project/Tasks management, Code library, language toolbox, compiler association, FTP support etc. As usual...submit early and often to get your shot at winning this great prize!
Make Extra Cash With Your Coding Skills!

Get first shot at extra cash by registering Now!
Check out the new RentACoder.com, the online reverse-auction marketplace that allows you to find paid coding odd-jobs from the comfort of your own home! Register today and make some extra cash! Or post your project and find coders to get the job done!
Planet Source Code eGroup!

Planet Source Code EGroup
Solve problems regarding code, announce the new versions of your programs published at Planet-Source-Code.com, request apps, and much more! Sign up for the new Planet Source Code eGroup today!
Ask a SQL Pro!

Got a sql or database question? Ask a pro for help in the 'Ask a Pro' Discussion Board!

Browse the largest code database on the net!
Compatibility Filter Profile:

SQL Server 2000
SQL Server 7.0
SQL Server 6.5 and earlier

Note: Stats below include both filtered and non-filtered items.

Coding Standards
(630 lines)

Data Conversion
(2,281 lines)

Data Warehouses
(502 lines)

Date/ Time
(1,493 lines)

Debugging and Error Handling
(46 lines)

Design/ Modeling
(432 lines)

Maintainence/ Optimization
(7,547 lines)

(6,613 lines)

(1,643 lines)

Numeric Manipulation
(463 lines)

(3,364 lines)


(319 lines)

(3,031 lines)

Space Management
(3,112 lines)

(984 lines)

(575 lines)

Stored Procedures
(6,012 lines)

String Manipulation
(3,346 lines)

(290 lines)

(71 lines)

Tuning Performance
(1,587 lines)

(271 lines)

Contest Winners


Winners for code submitted October 2003 as chosen by your votes!

Last month's submissions are in the process of being tallied and reviewed, and the winners will be announced shortly!

In the meantime, here are previous month's winners

Execute SQL on Multiple Tables/ColumnsNew feature in MS SQL SERVER 2000
The base idea of this article is to give leverage to run SQL Statement or Stored Procedure or User defined Function or set of SQL Statements


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.