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)
|
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...
|
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.
|
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.
|
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)
|
Random Rows of Data by John Cappelletti Language: SQL
A very simple technique to select random data from a SQL Server query
|
|