| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Demonstrate complex join expressions and bitwise comparisons within join expressions | SQL Server 7.0, SQL Server 6.5 and earlier, Informix
, Oracle, Other | Intermediate /
Chris Tucker | 3983 since
8/20/2001 4:52:46 PM | Unrated
|
| |
Demonstrate bitwise comparisons within joins and re-enforce the capabilities of join operations. |
| |
| |
| |
|
Demonstrate complex join expressions using bitwise comparison as an example. | SQL Server 7.0, SQL Server 6.5 and earlier, Informix
, Oracle, Other | Intermediate /
Chris Tucker | 8203 since
8/24/2001 6:33:32 PM |
By 1 Users
|
| |
Demonstrate complex join expressions using bitwise comparison as an example. |
| |
| |
| |
|
 Demonstrates fully-scrollable cursor.sql | SQL Server 7.0 | Intermediate /
Umachandar | 5757 since
7/13/2000 10:08:25 PM |
By 2 Users
|
| |
Shows how to use fully scrollable cursors in SQL Server 7.0. |
| |
| |
| |
|
Demonstrates how to join results from a SP with a normal table.sql | SQL Server 7.0 | Intermediate /
Umachandar | 6363 since
7/13/2000 10:20:55 PM |
By 1 Users
|
| |
Join results of a SP with another table. |
| |
| |
| |
|
Demonstrates how to join results from a Stored Procedure with a normal table output | SQL Server 2000, SQL Server 7.0 | Intermediate /
Kazi Khalid | 16125 since
4/20/2004 4:39:19 AM |
By 5 Users
4 Excellent Ratings
|
| |
Demonstrates how to join results from a Stored Procedure with a normal table output |
| |
| |
| |
|
 Denormalize your table data on the fly | SQL Server 2000 | Intermediate /
Vasilis Ioannidis | 4452 since
9/20/2002 5:18:34 AM |
By 3 Users
2 Excellent Ratings
|
| |
The purpose of this code is to help you easily transform-denormalize your data from your OLTP system to use it easily on a report system. (ScreenShot) |
| |
| |
| |
|
DETERMIN WHAT DATABASE YOU ARE IN | SQL Server 7.0 | Beginner /
pilot guy | 4392 since
5/13/2002 12:04:31 PM |
By 2 Users
|
| |
If you need to know what database you are in, run this query to get that name! |
| |
| |
| |
|
 Document SQL Server | SQL Server 2000 | Intermediate /
PeterTT | 9356 since
6/17/2003 10:04:51 AM |
By 1 Users
|
| |
re-submitted as zip so format should be better.
If not I am sure you will let me know!
This script will Print details including security group assignment on Tables, Stored Procedures, Views, User Defined Functions
I use it to help document my SQL database ...(description truncated) |
| |
| |
| |
 |
Does Row Exist | Oracle | Intermediate /
Andy Archer | 3111 since
9/21/2009 8:55:48 AM | Unrated
|
| |
Oracle developers commonly use "SELECT COUNT(*) INTO <variable>" in their PL/SQL as an easy way to see whether or not rows exist in a table. But this can be slow. Here's a PL/SQL stored function that takes a different, faster approach. |
| |
| |
| |
|
Dynamic SQL execution | SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Umachandar | 8711 since
7/29/2000 10:01:32 PM |
By 6 Users
|
| |
This method of dynamic SQL execution is not well-known. This will work from SQL60 & upwards. This is very useful when calling SPs dynamically with parameters of different datatypes, output parameters & return value. |
| |
(ScreenShot)
