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)

Multiple VALUES insert by Fernando Pires Language: SQL 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 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)

Quick Column Find by Rob Waibel Language: SQL Quickly find all tables/views that have a specific column name

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.

Introduction to PL/SQL (series2) by David Nishimoto Language: SQL 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 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...

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.

User Defined Function Intro by Lewis E. Moten III Language: SQL Brief introduction to user defined functions with examples and benefits explained.

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

FormatDate by Lewis E. Moten III Language: SQL Dynamically convert a date to a user-defined format.

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"!

Finally a LIMIT clause for MS SQL by _CodeJack_ Language: 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.

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

Quick Table Row Counts by Rob Waibel Language: SQL 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 by TheVBPro Language: SQL 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.

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.

Random Rows of Data by John Cappelletti Language: SQL A very simple technique to select random data from a SQL Server query

ISNUMERIC is not “ALL DIGITS” by Jeff Moden Language: SQL There are many cases where you need to ensure that the string data you are working with includes only numeric digits. Most Developers will use the built in ISNUMERIC function to make such a check. Here’s why that’s a bad idea and what to do about it.

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!

Execute SQL on Multiple Tables/Columns–New 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)

Send Fax With T-SQL Using MS-Word by TheIndoctrinator !! Language: SQL Hi This is My Fourth Submission named "Send Fax With T-SQL Using MS-Word. The following example, ("Full Commented to make it understand by VB Developers"), creates a Word document and retrieves its Application object, which it stores in an Integer variable which represents the COM pointer to the automation interface of the component. Next, it makes the Word application visible by setting the Application's Visible property to True, then it inserts some text into the Word document and ... (see entry for full description)

First and Last Date of Week by SikanderMandal Language: SQL I had problem in finding Week First and Last Date, but after 15 mins. I am able to get it wright. Please read this code and do vote for me.

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)