| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 SQL reference guide v.1.02 | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier, Other | Beginner /
Dcasso | 38019 since
11/2/2002 12:04:55 PM |
By 19 Users
14 Excellent Ratings
|
| |
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 an ...(description truncated) |
| |
| |
| |
|
 Split Function | SQL Server 2000 | Intermediate /
GuyH | 64568 since
4/2/2003 9:46:06 AM |
By 14 Users
12 Excellent Ratings
|
| |
Enables SQL Server to perform the Split Function in stored procedures/views/functions (ScreenShot) |
| |
| |
| |
|
 Pivot Table via Parameters | SQL Server 2000, SQL Server 7.0 | Advanced /
John Cappelletti | 36972 since
5/28/2003 4:51:28 PM |
By 13 Users
11 Excellent Ratings
|
| |
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, ST ...(description truncated)(ScreenShot) |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
 Decrypt MS SQL 2000 stored procedures of ANY SIZE! | SQL Server 2000 | Advanced /
Alexander Polozov | 17549 since
11/5/2002 3:03:54 AM |
By 10 Users
10 Excellent Ratings
|
| |
This MS Access application will decrypt Stored Procedures encrypted using "with encryption" option.
If automatic removing of "with encryption" option fails user will asked to manually modify the source of SP. The source of SP must start with “ALTER PROCED ...(description truncated)(ScreenShot) |
| |
| |
| |
 |
Oracle Apps 11i tutorial | Oracle | Advanced /
Dinesh Kumar S | 22479 since
1/7/2009 9:03:51 AM |
By 10 Users
10 Excellent Ratings
|
| |
A Beginners guide to oracle 11i - is a complete technical material for oracle 11i ERP. I have written this material for freshers or people new to this technology. Every Concepts is explained with practical scenario with examples & exercises. Hope this ...(description truncated) |
| |
| |
| |
|
ASP.NET Enterprise Manager (0.5.0) | SQL Server 2000 | Intermediate /
Wes Grant | 15761 since
9/29/2002 2:49:18 PM |
By 11 Users
10 Excellent Ratings
|
| |
This is a web-based version of Enterprise Manager for SQL Server and MSDE. An online demo is available at <a href="http://www.aspenterprisemanager.com/">http://www.aspenterprisemanager.com/</a>. This is an Open Source Project (ASP.NEt, VB.Net and AD ...(description truncated)(ScreenShot) |
| |
| |
| |
|
VFK. A View for Table Relationships; FOREIGN KEY and REFERENCED Table/Column names and its relations | SQL Server 2000 | Intermediate /
Raghavendra Narayana | 22989 since
4/8/2003 1:37:45 AM |
By 16 Users
10 Excellent Ratings
|
| |
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.(ScreenShot) |
| |
| |
| |
|
Business Entity Class Generator | SQL Server 2000, SQL Server 7.0 | Intermediate /
Leon Tayson | 18118 since
1/13/2006 8:10:56 PM |
By 9 Users
9 Excellent Ratings
|
| |
This SP accepts a database object name (table, view) parameter and generates (C# code) custom entity class based on the object's fields. You can then copy and paste the generated code to your C# class.(ScreenShot) |
| |
| |
| |
|
Finally a LIMIT clause for MS SQL | SQL Server 2000, SQL Server 7.0 | Intermediate /
_CodeJack_ | 199266 since
6/29/2004 3:56:31 PM |
By 10 Users
9 Excellent Ratings
|
| |
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. |
| |
| |
| |
|
SQL2PDF | SQL Server 2000 | Advanced /
Ivica Masar | 9053 since
8/30/2003 3:50:16 PM |
By 11 Users
9 Excellent Ratings
|
| |
Create a PDF from SQL table(ScreenShot) |
| |
(ScreenShot)
(ScreenShot)
(ScreenShot)
(ScreenShot)
(ScreenShot)
(ScreenShot)
(ScreenShot)
