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+