SQL, database, informix, oracle, SQL Servertutorial, newbie, beginner, how, to, how to program, help
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: 30,146 lines
 Jobs: 359 postings

 
Sponsored by:

 

You are in:

 
Login



Latest Code Ticker for SQL.
Access 2000 Calculating Working Days
By David Nishimoto on 10/3


using the CUME_DIST Oracle analytic function
By Eli Leiba on 10/2


Click here to see a screenshot of this code!Visual Basic Data Mining With Na´ve Bayes Version 2.0 New Release
By http://www.visu al-basic-data-m ining.net on 10/2

(Screen Shot)

Drop User-defined Indexes
By Peter Wilkinson on 10/1


Splitting text for search purposes
By Christoffer Munck on 10/1


Click here to see a screenshot of this code!ASP Enterprise Manager
By Wes Grant on 9/29

(Screen Shot)

Introduction to PL/SQL (series2)
By David Nishimoto on 9/27


ColDefinition or helping upsert SP writing
By Pollus Brodeur on 9/26


Oracle PLSQL series 1
By David Nishimoto on 9/21


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.

A Data Warehouse Tutorial
by http://www.visual-basic-data-mining.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)

Renumbering identity columns
by Mustafa YUCEL
Language: SQL

Renumbering identity column of a table in a scripting manner

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)

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.

Got constraints? ERP does not.
by Steven Hauser
Language: SQL

The question of database level enforced constraints vs programmer applied constraints is asked occasionally by people who have not done much database development work.

Splitting text for search purposes
by Christoffer Munck
Language: SQL

This is a simple, but useful, script on how to split text into a temp table. This enables you to perform different types of searches

Reverse SUBSTR clip
by Jason
Language: SQL

You can use negative numbers with the SUBSTR functions in Oracle.

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...

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

User Defined Function Intro
by Lewis Moten
Language: SQL

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

FormatDate
by Lewis Moten
Language: SQL

Dynamically convert a date to a user-defined format.

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.

Implementing Multilevel ranking in T-SQL
by Harinatha Reddy Gorla
Language: SQL

These are one of the tricky methods where we have adopt different logic. This snippet will give you an idea how to implement multilevel ranking

Use XML as a stored procedure parameter in SQL 2000!
by Brandon McPherson
Language: SQL

In SQL 2000, most of the XML documentation involves using IIS to pass the data in, or Visual Basic. However, you can also simply pass the XML code itself as an ntext parameter, and just load it in as though it were a recordset. See the below example on the Northwind database.

Creating XML in a Stored Procedure
by The_Mat_in_the_Hat
Language: SQL

Use a cursor in a stored procedure to create short XML string to output rather than recordsets. Also included is a simple VB application (with source) that generates the SQL

Do you have to review your backup strategy?
by Found on the World Wide Web
Language: SQL

Information in this article applies to: Microsoft SQL Server Version 7.0 Microsoft SQL Server makes many tasks easier. Especially organizing the backup and recovery process has become much easier, because no devices have to be created and the database itself can also be rebuild automatically. But if you plan to be able to recover your data up to the point of failure then be aware of some restrictions!

Handling delimited strings in T-SQL
by Harinatha Reddy Gorla
Language: SQL

There may be cases where you want to work with delimited strings in T-SQL. Following two examples will cover most of the stuff that you will face while working with strings.

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!

Sending mail messages in oracle
by Eli Leiba
Language: SQL

a Procedure to send an email message in Oracle 8i

using the CUME_DIST Oracle analytic function
by Eli Leiba
Language: SQL

Showing how to select a N percent portion from the DATASET (top OR bottom)

Find word in multiple fields whith instr
by Fernando Pires
Language: SQL

Find word in multiple fields

DBCC Log
by Keith Henry
Language: SQL

Viewing the Tranaction log in MS SQL 7+

 



Newest Tutorials

Access 2000 Calculating Working Days
by David Nishimoto
10/3/2002 12:30:35 PM

Language: SQL

This article explains how to use Access 2000 date functions when determining 1) the number of work days representing an interval between two dates 2) the projected end working date calculated from a start date and number of hours worked.

using the CUME_DIST Oracle analytic function
by Eli Leiba
10/2/2002 7:18:54 AM

Language: SQL

Showing how to select a N percent portion from the DATASET (top OR bottom)

Visual Basic Data Mining With Na´ve Bayes Version 2.0 New Release
by http://www.visual-basic-data-mining.net
10/2/2002 1:48:52 AM

Language: SQL

October 1, 2002: visual-basic-data-mining.net is pleased to announce the release of their visual basic data mining application. Developed with Visual Basic 6, Visual Basic Data Mining With Na´ve Bayes Version 2.0 Release is designed for data mining on relational databases (RDBMSs) including Microsoft« Access«, Microsoft SQL Server«, etc. The application features a wizard driven data mining GUI guide and is available for free download with the source code at http://www.visual-basic-data-mining. ... (see entry for full description)

Splitting text for search purposes
by Christoffer Munck
10/1/2002 5:51:12 AM

Language: SQL

This is a simple, but useful, script on how to split text into a temp table. This enables you to perform different types of searches

Introduction to PL/SQL (series2)
by David Nishimoto
9/27/2002 6:53:11 PM

Language: SQL

Welcome back to Introduction to PL/SQL I'll be describing Select, Insert, Update, and Delete; all the CRUID about data manipulation.

ColDefinition or helping upsert SP writing
by Pollus Brodeur
9/26/2002 11:22:42 PM

Language: SQL

Help programmers to easily build insert/update stored procedures. It will create almost all the TSQL code for you.

Oracle PLSQL series 1
by David Nishimoto
9/21/2002 9:01:19 PM

Language: SQL

I'm starting a Oracle PLSQL series of articles. After extreme demand to share my experiences learning PL/SQL, I will be creating a six to seven week - series. Make sure to join in and share ideas. Next week, I'll be covering various methods for data manipulation language (dml):select, insert, delete, and update

How to Load a Category Tree and Listbox RowSourceType - "field value"
by David Nishimoto
8/30/2002 11:52:23 AM

Language: SQL

In this Access 2000 article, I will show you how to create a category tree and load it into a listbox. In this article, I will demonstrate the steps to create a static value list and associate it with a listbox. The algorithm can be easily ported to a treeview control or html for an active server page.

How to Create menus/submenus using Access 2000
by David Nishimoto
8/27/2002 2:11:34 PM

Language: SQL

My experience with menus has been with Visual C++ and Visual Basic. Both Visual Basic and Visual C++ have wizards helping the developer easily create menu items and subitems attaching code for onclick events. However, Access 2000 does not. Access 2000 menus are easy once you understand the manual steps. This article will walk you step by step through creating an Access 2000 menu.

Creating your own Access2000 validation routines
by David Nishimoto
8/26/2002 1:45:02 PM

Language: SQL

This article explains how to create your own Access 2000 validation routines. Access2000 has ValidationRules you can create for each control. However, I found it easier to use Visual Basic techniques to validate my data.


 

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.