| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 generate a schema from scratch | SQL Server 2000 | Beginner /
Joey Filichia | 3950 since
12/2/2004 9:47:01 PM | Unrated
|
| |
The purpose of this code is to generate a simple list of table names..column names. |
| |
| |
| |
|
Generate a virtual table from 5 integer values | SQL Server 6.5 and earlier | Beginner /
Umachandar | 3621 since
7/25/2000 8:27:57 PM | Unrated
|
| |
For newbies. |
| |
| |
| |
|
Generate random questions in a quiz application | SQL Server 2000 | Beginner /
Developer142 | 6162 since
7/2/2009 9:02:20 AM |
By 1 Users
|
| |
To Generate random questions in a quiz application |
| |
| |
| |
|
 GEO Query | SQL Server 7.0 | Beginner /
Kevin Pirkl | 2570 since
4/23/2002 2:25:19 PM | Unrated
|
| |
Provides a SQL example routine for doing Geographic Radial Searching and a lot of information regarding GEO Coding and formulas. |
| |
| |
| |
|
get the default server collation | Other | Intermediate /
Eli Leiba | 5823 since
12/20/2001 8:03:46 AM |
By 1 Users
|
| |
in SQL SERVER 2000 getting the server's default collation |
| |
| |
| |
|
Get Web Data | SQL Server 2000 | Intermediate /
Pankaj Adhikari | 2837 since
6/17/2011 10:41:24 AM | Unrated
|
| |
Retrieves data from web site |
| |
| |
| |
|
Getting file details (alternative method ) | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 3477 since
7/29/2000 9:59:30 PM | Unrated
|
| |
Getting file details is easy using the undocumented extended SP 'xp_getfiledetails'. But you can't rely on this to be the same between versions of SQL Server or even service packs. So here is an alternative method using the standard NT commands. The undoc ...(description truncated) |
| |
| |
| |
|
Giftland Wedding DBMS | Oracle | Beginner /
Mo Maz | 2310 since
7/25/2004 5:05:03 AM | Unrated
|
| |
I have developed this DBMS as part of my assignment for one of my modules. It's a DBMS for weddings. It is not a great design but can form a basis for anyone who would like to develop a database using Oracle SQL Plus. I hope someone designs it much better ...(description truncated) |
| |
| |
| |
 |
grant a privilege on all user tables to another user | Oracle | Advanced /
Andy Archer | 4037 since
6/22/2010 8:38:27 AM | Unrated
|
| |
This script solicits a table privilege and grantee user name at the SQL*Plus prompt, then builds and executes a file of GRANT statements to grant the privilege on all user tables to the grantee user. |
| |
| |
| |
|
Hacks for relational algebra. | SQL Server 7.0, Informix
, Oracle, Other | Beginner /
Steven Hauser | 6039 since
7/11/2000 10:52:24 PM |
By 2 Users
|
| |
SQL is a language that does not do some
relational algebra very easily.
Here are some examples of SQL trying to do the
relational algebra operations of difference,
simple division and partition.
Other operations like intersect also need subqueries
but ...(description truncated) |
| |
