|Writing a Stored Procedure|
by Nathan Pond
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|
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|
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 User Interface Developers
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)
|SQL reference guide v.1.02|
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.
Insert, delete or update rows,
Insert, delete or change tables,
and Sub queries.
It's in PDF to make sure that it will o ... (see entry for full description)
|Multiple VALUES insert|
by Fernando Pires
Use this little trick to INSERT MULTIPLE row values instead of using multiple INSERT statements to improve performance and typing.
|Introduction to PL/SQL (Series 3) Cursors|
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)
|Quick Column Find|
by Rob Waibel
Quickly find all tables/views that have a specific column name
|Access 2000: Controlling Report Data|
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.
|Introduction to PL/SQL (series2)|
Welcome back to Introduction to PL/SQL
I'll be describing Select, Insert, Update, and Delete; all the CRUID about data manipulation.
|pl/sql mega tutorial|
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...
|Finally a LIMIT clause for MS SQL|
This query gives you the same ability as a LIMIT clause does in MySQL and Oracle for MS SQL Server without the headaches of stored procedures or temp tables.
by Lewis E. Moten III
Dynamically convert a date to a user-defined format.
|UNION statements in MySQL 3.x|
by Michael Bailey
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
|Quick Table Row Counts|
by Rob Waibel
Just run it from Query Analyzer and choose a DB.
No modification is needed. It saves a great deal of time in getting counts in an entire DB.
|Introduction to SQL with MS-Access|
This is a comprehensive, hands-on introduction to SQL, using a modified version of the "Northwind Traders" MS-Access database. Covered are basic and advanced SELECT statements, JOINs, UNIONs, INSERTs, UPDATEs, DELETEs, as well as DDL statements such as CREATE TABLE, ALTER TABLE, constraints, and more.