SQL, database, informix, oracle, SQL Server
Quick Search for:  in language:    
SQL, database, informix, oracle, SQL Server,tutorial, newbie, beginner, how, to, how to program, help
   Code/Articles  |  Newest/Best  |  Community  |  Jobs  |  Other  |  Goto  | 
CategoriesSearch Newest CodeCoding ContestCode of the DayAsk A ProJobsUpload
SQL Stats

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

 How to support the site

 
Sponsored by:

 
You are in:
 

Does your code think in ink?
Login





Latest Code Ticker for SQL
Create thousand Data Base users quickly
By N.D.I.Samantha on 1/1


Numbers from String
By Jeff Michelson on 12/30


Number to words in a single query
By Joseph Varghese on 12/24


Click here to see a screenshot of this code!The Best Columns to Index
By Sherenato on 12/23

(Screen Shot)

Click here to see a screenshot of this code!SQL 2 String-lists comparison
By Mohamed EL-Zahaby on 12/18

(Screen Shot)

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



 
 

Articles and Tutorials

Most Popular  
The articles and tutorials other users have found the most useful.  Broken out by beginner, intermediate and advanced level.
 
Newest  
Stay up to date with the latest and greatest!
 
To access the entire archive of articles and tutorials simply use the 'Browse All Categories' and 'Search' menu items in the drop-down hot menu at the top of the screen.

Most Popular

Beginner

Intermediate

Advanced

Writing a Stored Procedure
by Nathan Pond
Language: SQL

This article is geared for beginners wanting to learn stored procedures. No prior experience on stored procedures is required, however a basic understanding of SQL Query Language might be needed.

SQL In Simple English - Part 1
by Kiran Pai
Language: SQL

I have found that many articles found on the net are good and detailed but they are not really friendly to novice programmers. In my article the topic is presented as a Q&A; session. Most of the questions are the ones that most novices would like to ask. This approach is excellent and readers who aren not familiar with the technology. Since this article is totally language neutral, programmers using any language and who want to do database programming will find it useful.

SQL In Simple English - Part II
by Kiran Pai
Language: SQL

This is the second article in this series. If you liked the first one, you will definitely like this one too. 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.

SQL reference guide v.1.02
by Dcasso
Language: SQL

This is a little piece of paper which I made for the classes which I teach in VB, and this reference guide has been made for use with ACCESS-databases but should work with SQL SERVER. It is a reference guide to SQL with the most used commands, elements and more. It includes: General SQL-structures, Simple operations, Joins, Functions, Aggregation, Insert, delete or update rows, Insert, delete or change tables, Unions, and Sub queries. It's in PDF to make sure that it will o ... (see entry for full description)

A Data Warehouse Tutorial
by VISUAL-BASIC.NET
Language: SQL

A tutorial that explains data warehousing concepts. Concepts include data warehouse, data mart, benefits of data warehousing, OLAP, OLTP, dimensions, fact tables, measures, aggregations, cubes, PivotTable Service, offline OLAP cubes, virtual cubes, MOLAP cubes, ROLAP cubes, HOLAP cubes. Attached is this article in Micrsoft Word™ format. Submitted by Pareto Analyst (www.paretoanalysts.com)

Introduction to PL/SQL (Series 3) Cursors
by David Nishimoto
Language: SQL

PL/SQL introduces a new dimension of power programming capability for the developer. The goal of reusable code measurely improves quality verse vast amounts of non-reusable SQL. PL/SQL packages describe function and procedure specification and body. The specification describes the package interface to the calling application. The package specification approach is part of good design. The package specification exposes procedures and their parameter properties to external applications ... (see entry for full description)

Renumbering identity columns
by Mustafa YUCEL
Language: SQL

Renumbering identity column of a table in a scripting manner

MS SQL Server 7.0 OLAP Services FAQ
by Vasilis Ioannidis
Language: SQL

The following section lists some of the commonly asked questions and answers about SQL Server 7.0 OLAP Services.

Questions and Answers abut SQL Server and MSDE Interoperability
by Found on the World Wide Web
Language: SQL

Answers to common questions on MSDE/SQL Server Interopability (http://www.programmingmsaccess.com/FAQs/SQLServer.htm)

Access 2000: Controlling Report Data
by David Nishimoto
Language: SQL

It is often the case a developer will need to create an Access 2000 reports application capable of data selection. For example, all transactions for a member. The data is input as parameters with in a form and passed to the report as query criteria. This is the simplest method to control report output resulting from user selected data criteria.

pl/sql mega tutorial
by somdutt ganguly
Language: SQL

This is a great 50 pages notes/tutorials on pl/sql blocks, exception handling, procedures, functions, triggers, packages....u will learn all about advance procedure languages in oracle...There are about 50 programs....nice article i believe....plz do vote for my hard work...

User Defined Function Intro
by Lewis Moten
Language: SQL

Brief introduction to user defined functions with examples and benefits explained.

Stored Procedures - send anonymous email over smtp
by Pange
Language: SQL

This SP sends an email over SMTP with SQL Server 2000! It need's enough rights and "CDO for Windows 2000"!

Join the results of a stored procedure in T-SQL : A Clean Sample
by Harinatha Reddy Gorla
Language: SQL

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

VFK. A View for Table Relationships; FOREIGN KEY and REFERENCED Table/Column names and its relations
by Raghavendra Narayana
Language: SQL

Screwed up with the Table relationships??? Here is a Database View to see the relationships of tables. It is easy to identify the foreign/referenced table/column names and its relationships using this view.

UNION statements in MySQL 3.x
by Michael Bailey
Language: SQL

Everyone who uses MySQL realizes eventually that while being a very powerful SQL server, a number of options are missing. One of these is the UNION statement. Here's how to do it in MySQL 3.x

FormatDate
by Lewis Moten
Language: SQL

Dynamically convert a date to a user-defined format.

Numeric Month
by Raghavendra Narayana
Language: SQL

Here is a different way to get the month in number for character month. This is simple and you need not to use Date functions.

What is errorlog under LOG and can I disable it, move it, or even rename it? (SQL Server Log)
by James Travis
Language: SQL

To provide information about system properties developers and administrators may not be aware of or fully understand.

Data Mining For Database Developers - 1Rule
by VISUAL-BASIC.NET
Language: SQL

A Data Mining application for Relational Databases (RDBMS) including Microsoft Access, Microsoft SQL Server , Oracle and Sybase databases.The attached articles in HTML and Microsoft Word gives a detailed step by step guide to the development of a Data Mining application. Interested programmers can download more freeData Mining Source Code from http://www.visual-basic-data-mining.net. Also included is a free complete implementation of a data mining algorithm in Microsoft Access ... (see entry for full description)

Pivot Table via Parameters
by John Cappelletti
Language: SQL

Pivot any table with just a few parameters. This utility was designed for adhoc analaysis and to serve as a workhorse. There is very little error trapping and would welcome any suggestions. Choose the Aggregate Function, i.e. Sum, Count, Avg, Min, Max, STD... Colums and rows may be expressions. Any valid filter may also be applied. When I don't want any filter, I simply set the expression to 1=1.

OpenRowSet w/Parameters
by Louis Davis
Language: SQL

Steps to use parameters with the OPENROWSET function.

How to rename a SQL user login
by James Travis
Language: SQL

To demonstrate how to effectively rename SQL user account without dropping and recreating them. The following method and information is primamrily for educational purpose only.

Send email through PL/SQL
by Gnu Kemist
Language: SQL

This stored procedure will allow you to send email to your users (or even yourself) with job status or even serve as an error reporting tool for your application. You could call it from other stored procedures or triggers upon insert/update/delete statements; or call it from a visual basic application to send you an email when an error occurrs; The uses are almost that unlimited! You can improve this procedure to send HTML or XML emails... Have fun and please vote!

Code stored in Binary/Text files instead in Stored Procedures-SQL SERVER
by Raghavendra Narayana
Language: SQL

The base idea of this article is to extend the boundary of SQL Server by introducing Code/part of code stored in ASCII/Binary/other file format in same/different server. The code of the Stored Procedures or User Defined Functions need not to reside only in SP/UDF, you can have the code/part of code in ASCII/Binary/Other file format and stored under specific server/folder. This concept is useful while introducing .INI file concept in SQL Server. Plus you can avoid re-compilation of S ... (see entry for full description)

Execute SQL on Multiple Tables/ColumnsNew feature in MS SQL SERVER 2000
by Raghavendra Narayana
Language: SQL

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 on every/required tables and on every/required columns in the Database. There would have been a requirement like you wanted to add/edit/delete/search data in column(s) on more than one table using a single SQL statement, and you ended up with writing a procedure/function for achieving it. Here you now equipped with SP_execSQLonDB stored procedu ... (see entry for full description)

Recycle feature in MS SQL Server 2000
by Raghavendra Narayana
Language: SQL

We can find a lot of stuff on SQL Select, Insert and etc. There are few articles/discussions on SQL DELETE. Here is an idea about SQL DELETE statement. If the data is deleted from the tables without using Transactions, there is no way for Developers to retrieve it back, probably DBAs or certain tools may retrieve it back for you. Here is an effort to give a little leverage to Developers in dealing with record deletion. This Stored Procedure accepts DELETE SQL statement and c ... (see entry for full description)

Using Built-In Functions(GETDATE()) in UDF
by NAGABHUSHANAM
Language: SQL

How to use built_in functions inside a UDF.

Random Rows of Data
by John Cappelletti
Language: SQL

A very simple technique to select random data from a SQL Server query

Sending mail messages in oracle
by Eli Leiba
Language: SQL

a Procedure to send an email message in Oracle 8i

 



Newest Tutorials

Group Data Values
by Thivya Prabakaran
11/29/2003 1:57:39 AM

Language: SQL

Often we have to group certain values by providing their id's. If the id's are seperated by comma's, this function gives you the simple methodology rather than parsing one by one.

Grouping Data
by Thivya Prabakaran
11/29/2003 1:44:49 AM

Language: SQL

Often we have to group certain values by providing their id's. If the id's are seperated by comma's, this function gives you the simple methodology rather than parsing the id's one by one.

Brief Tutorial on Text, Ntext, and Image
by Joseph Gama
11/8/2003 2:02:55 PM

Language: SQL

MSDN article Using Text, Ntext, and Image. From the basics to very elaborate cases such as using file IO, conversions, extc.

How to remove excessive spaces
by Kaczyski Grzegorz
10/31/2003 2:37:53 AM

Language: SQL

How to remove excessive spaces from column in your table? Example: how to convert 'dupa___jasiu______pierdzi___stasiu' to 'dupa_jasiu_pierdzi_stasiu' (tested only with varchar) :).

Proper Case All Words
by Tim Cook (Intellisoft)
10/14/2003 3:11:01 PM

Language: SQL

I needed to Proper Case All words from a Name field used in our EDI processing. The name(s) could not contain consecutive capitals or spaces. I found this code http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=300&lngWId;=5 here but it just made sure the first letter of each word was capitalized. This UDF will capitalize the first letter of each word and force all other letters to lower case. It will also remove any consecutive spaces and make them 1 space between words. Thanks to ... (see entry for full description)

Code stored in Binary/Text files instead in Stored Procedures-SQL SERVER
by Raghavendra Narayana
9/26/2003 3:48:29 AM

Language: SQL

The base idea of this article is to extend the boundary of SQL Server by introducing Code/part of code stored in ASCII/Binary/other file format in same/different server. The code of the Stored Procedures or User Defined Functions need not to reside only in SP/UDF, you can have the code/part of code in ASCII/Binary/Other file format and stored under specific server/folder. This concept is useful while introducing .INI file concept in SQL Server. Plus you can avoid re-compilation of Stored Procedu ... (see entry for full description)

Execute SQL on Multiple Tables/ColumnsNew feature in MS SQL SERVER 2000
by Raghavendra Narayana
9/11/2003 2:40:19 AM

Language: SQL

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 on every/required tables and on every/required columns in the Database. There would have been a requirement like you wanted to add/edit/delete/search data in column(s) on more than one table using a single SQL statement, and you ended up with writing a procedure/function for achieving it. Here you now equipped with SP_execSQLonDB stored procedure that runs ... (see entry for full description)

Function to obtain Last Days of Months
by Webmaster For LifeInTheVine.Com
9/5/2003 1:43:28 PM

Language: SQL

This is a function that returns a table containing the last days of months in a specified number of following years.

Store Key New RDBMS Concept in MS SQL SERVER 2000
by Raghavendra Narayana
8/27/2003 1:23:31 AM

Language: SQL

Here is a new RDBMS concept, Store Key alias SK. In simple terms you store all the redundant data of a database in one table and use it whenever/wherever required via Store Key ID alias SKID. This article targets the redundant data as well as RDBMS Normalization concept. The base idea of normalization is storing the redundant data in another table and creating a link between the divided tables. Normally we store the redundant data in Table X and have the Foreign Key relation to the actua ... (see entry for full description)

Numeric Month
by Raghavendra Narayana
8/22/2003 5:06:33 AM

Language: SQL

Here is a different way to get the month in number for character month. This is simple and you need not to use Date functions.


 

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.