Important alert: (current site time 4/19/2014 12:44:39 PM EDT)
 

All Time Best Code/Article/Tutorial Hall of Fame (by ranking)

Search Results: Page 1 of 68 found. Entries 1 - 10 of 677 found
Jump to page: 1 2 3 4 5 6 ...

  Description
Compatibility
Level/
Author
Views/
Date
Submitted
User Rating
 
  Writing a Stored ProcedureWriting a Stored ProcedureSQL Server 7.0Beginner /
Nathan Pond
265853 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 tutorialpl/sql mega tutorialOracleIntermediate /
pompyk
65183 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 1SQL In Simple English - Part 1SQL Server 7.0, SQL Server 6.5 and earlier, Oracle, Other Beginner /
KP
69897 since
3/5/2002 2:12:50 AM

By 37 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)DECRYPT SQL SERVER 2000 STORED PROCEDURES, VIEWS AND TRIGGERS (WITH EXAMPLES)SQL Server 2000Advanced /
Joseph Gama
343381 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)Click here to see a screenshot of this code!(ScreenShot)
 
 
  Tedious queries 150Tedious queries 150OracleIntermediate /
pompyk
23367 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 IISQL In Simple English - Part IISQL Server 7.0, SQL Server 6.5 and earlier, Oracle, Other Beginner /
KP
37022 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_123 TSQL functions updated 09-08-2002SQL Server 2000Intermediate /
Joseph Gama
105027 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)Click here to see a screenshot of this code!(ScreenShot)
 
 
  A Data Warehouse TutorialA Data Warehouse TutorialSQL Server 7.0, Other Beginner /
User Interface Developers
222532 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)Click here to see a screenshot of this code!(ScreenShot)
 
 
  SQL Server Paging Grand Tourismo!SQL Server Paging Grand Tourismo!SQL Server 2000Beginner /
Andrew Carrasco
19748 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 procedureIntegrated database documentation using stored procedureSQL Server 2000, SQL Server 7.0Advanced /
Christina McEntire
26423 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)
 


Search Results: Page 1 of 68 found. Entries 1 - 10 of 677 found
Jump to page: 1 2 3 4 5 6 ...


Compatibility Filter Profile:

SQL Server 2000
SQL Server 7.0
SQL Server 6.5 and earlier
Informix
Oracle
Other