| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Writing a Stored Procedure | SQL Server 7.0 | Beginner /
Nathan Pond | 262021 since
7/21/2000 1:12:46 PM |
By 126 Users
98 Excellent Ratings
|
| |
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. |
| |
| |
| |
|
 pl/sql mega tutorial | Oracle | Intermediate /
pompyk | 64471 since
5/14/2002 3:10:15 PM |
By 59 Users
45 Excellent Ratings
|
| |
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 ...(description truncated) |
| |
| |
| |
|
SQL In Simple English - Part 1 | SQL Server 7.0, SQL Server 6.5 and earlier, Oracle, Other | Beginner /
KP | 69113 since
3/5/2002 2:12:50 AM |
By 36 Users
29 Excellent Ratings
|
| |
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. T ...(description truncated) |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
 DECRYPT SQL SERVER 2000 STORED PROCEDURES, VIEWS AND TRIGGERS (WITH EXAMPLES) | SQL Server 2000 | Advanced /
Joseph Gama | 337476 since
7/9/2002 6:26:39 AM |
By 31 Users
25 Excellent Ratings
|
| |
This SP will decrypt Stored Procedures, Views or Triggers that were encrypted using "with encryption"
There are 2 versions: one for SP's only and the other one for SP's, triggers and views
version 1:
INPUT: object name (stored procedure, view or trigger)
...(description truncated) (ScreenShot) |
| |
| |
| |
|
Tedious queries 150 | Oracle | Intermediate /
pompyk | 22847 since
4/17/2002 1:05:24 AM |
By 31 Users
22 Excellent Ratings
|
| |
These are the worlds most tedious queries....all r solved. If you solve these queries then u will become the master of sql...This shows examples of using joins, subqueries, functions etc etc....just look in...and do vote for me for my work.....thx....The ...(description truncated) |
| |
| |
| |
|
SQL In Simple English - Part II | SQL Server 7.0, SQL Server 6.5 and earlier, Oracle, Other | Beginner /
KP | 36386 since
5/3/2002 2:48:53 AM |
By 20 Users
20 Excellent Ratings
|
| |
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 beginn ...(description truncated) |
| |
| |
| |
|
_123 TSQL functions updated 09-08-2002 | SQL Server 2000 | Intermediate /
Joseph Gama | 103331 since
7/2/2002 2:52:50 AM |
By 22 Users
20 Excellent Ratings
|
| |
This is a collection of 123 TSQL functions for professional, academic or learning purposes. There are many conversions hexadecimal/octal/binary/Roman numerals, mathematical functions such as hyperbolic, logic and trigonometric. Combinatorial functions suc ...(description truncated)(ScreenShot) |
| |
| |
| |
|
A Data Warehouse Tutorial | SQL Server 7.0, Other | Beginner /
User Interface Developers | 220122 since
12/27/2001 6:14:26 PM |
By 25 Users
16 Excellent Ratings
|
| |
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 ...(description truncated)(ScreenShot) |
| |
| |
| |
|
 SQL Server Paging Grand Tourismo! | SQL Server 2000 | Beginner /
Andrew Carrasco | 19161 since
7/9/2003 7:09:37 PM |
By 15 Users
15 Excellent Ratings
|
| |
This is a stored procedure that will allow you to page through a result set that has been generated with arbitrary SQL. This code is generic and will allow paging of ANY SQL statement except for execute statements. So, basically, ALL selects will work. It ...(description truncated) |
| |
| |
| |
|
Integrated database documentation using stored procedure | SQL Server 2000, SQL Server 7.0 | Advanced /
Christina McEntire | 25497 since
6/12/2003 1:54:21 PM |
By 17 Users
15 Excellent Ratings
|
| |
This stored procedure will help you to document your database within the database. It creates/updates a table that lists all of the user tables, views and stored procedures in the database, as well as all of the views and stored procedures that reference ...(description truncated) |
| |
(ScreenShot)
(ScreenShot)
(ScreenShot)
