| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 find all object privileges, system privileges, and roles granted to a user or role | Oracle | Advanced /
Andy Archer | 5350 since
3/13/2009 9:03:31 AM | Unrated
|
| |
These two SQL*Plus scripts run SQL to find all privileges and roles granted to a specified user or role. Each script spools its output to a file which is then opened in Notepad. |
| |
| |
| |
|
 Find non-server-default column collation | SQL Server 2000, SQL Server 7.0 | Advanced /
Brent Glover | 3079 since
4/23/2002 8:24:33 PM |
By 1 Users
|
| |
Finds all columns in a database that has a collation sequence different to the Servers default |
| |
| |
| |
|
Find out which service pack is installed. | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Peter Schmitz | 5370 since
12/5/2001 12:07:16 PM |
By 9 Users
6 Excellent Ratings
|
| |
Run from Query Analyzer to find out which Service Pack is installed. Updated now to include more versions of SQL Server 6.5 and 7.0. |
| |
| |
| |
|
Find the number of days in a month | SQL Server 6.5 and earlier | Beginner /
Umachandar | 5404 since
7/25/2000 8:27:06 PM |
By 2 Users
|
| |
Find the number of days in a month |
| |
| |
| |
|
 Find The T-SQL Objects Used In A Stored Procedure | SQL Server 2000 | Beginner /
Dave Vroman | 6355 since
9/23/2007 9:07:12 PM | Unrated
|
| |
Use This Query To Find The Names And Types Of The T-SQL Objects Used In A Stored Procedure.
This Is Especially Helpful When You're Trying To Debug Someone Elses Code. |
| |
| |
| |
|
FindDupes | SQL Server 7.0 | Beginner /
Greg | 21737 since
11/10/2000 4:00:14 PM |
By 10 Users
8 Excellent Ratings
|
| |
Allows you to determine duplicate rows in a table and provide a count of the duplicates.
It's helped me find a row or two that had left me with "inconclusive" results in the past : )
Ciao;
Greg |
| |
| |
| |
|
Finding all Possible Activity Paths in an MSproject 98 activity network using pl/sql sp | Oracle | Advanced /
Eli Leiba | 4052 since
3/6/2002 6:54:23 AM |
By 1 Users
|
| |
Microsoft Project represent a network of defined activities (called a project)
in an mpp file.
you can save the WHOLE project into
a database (like Oracle) and then
all the 38 tables supporting the project defintion will be created
Task_Dependencies is t ...(description truncated) |
| |
| |
| |
|
fn_CalculateAgeFromInt | SQL Server 2000 | Intermediate /
Peter Marquie | 3097 since
2/1/2003 8:24:07 PM | Unrated
|
| |
THIS FUNCTION CALCULATES A PERSON'S AGE BASED ON NUMBER OF DAYS SINCE 1900-01-01 00:00:000. |
| |
| |
| |
|
fn_GetDateFromIntegerDate | SQL Server 2000 | Intermediate /
Peter Marquie | 3994 since
2/1/2003 8:29:47 PM | Unrated
|
| |
IF YOU STORE YOUR DATES AS AN INTEGER I.E. THE NUMBER OF DAYS SINCE 1900-01-01 00:00:000 THEN THIS FUNCTION CAN COME IN HANDY TO DETERMINE THE ACTUAL DATE BY CONVERTING THE INTEGER VALUE TO A CALENDAR DATE |
| |
| |
| |
|
freeze your PL/SQL's execution until a condition has been met | Oracle | Intermediate /
Andy Archer | 1606 since
2/29/2012 5:28:11 PM | Unrated
|
| |
This block illustrates a technique for putting your PL/SQL's execution into "suspended animation" until a condition has been met. The technique involves a loop, counter, and DBMS_LOCK.SLEEP ...all wrapped around the condition check. |
| |
