| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Export/Import sp that uses BCP | SQL Server 7.0 | Intermediate /
Eli Leiba | 9414 since
2/20/2002 7:24:27 AM |
By 6 Users
3 Excellent Ratings
|
| |
a TSQL system tool to export/import data
given a database,table,filepath,exp/imp mode
seperator character and valid sql standard login |
| |
| |
| |
|
Filter duplicate records from a table | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier, Informix
, Oracle | Advanced /
Geoff Kazzi | 8806 since
11/25/2003 3:10:06 PM |
By 2 Users
|
| |
Deletes duplicate records from a table |
| |
| |
| |
|
 find blocking locks | Oracle | Advanced /
Andy Archer | 2595 since
11/5/2008 11:33:55 AM |
By 1 Users
|
| |
This SQL*Plus script executes a PL/SQL block to quickly display detailed data on sessions which are blocking (or are blocked by) the locks of other sessions. If necessary, a session can then be killed to release a lock. |
| |
| |
| |
|
find depended objects | SQL Server 2000, SQL Server 7.0 | Advanced /
chandra sekhar | 3816 since
11/19/2003 6:17:40 AM |
By 1 Users
|
| |
handle - cr's
you cant find all the depended objects by using sp_depends ,if you are execute a string which contains a table inside a stored procedure, but this function will give you a list of objects |
| |
| |
| |
 |
find server object dependencies with this UTLDTREE wrapper script | Oracle | Advanced /
Andy Archer | 4639 since
11/11/2008 1:33:12 PM |
By 1 Users
|
| |
This script solicits a user object name and type at the SQL*Plus prompt, employs Oracle's UTLDTREE.SQL objects to find the object's dependencies, spools the results to a file, and opens the file in Notepad. |
| |
| |
| |
|
 Find word in multiple fields whith instr - A step ahead | SQL Server 7.0, SQL Server 6.5 and earlier, Informix
, Oracle, Other | Intermediate /
Marco Vieira | 7213 since
1/15/2001 3:27:08 PM |
By 1 Users
|
| |
Optimize multi-field string query |
| |
| |
| |
|
Generate a report of the locks in a database | SQL Server 6.5 and earlier | Intermediate /
Umachandar | 4591 since
8/11/2000 12:07:30 PM |
By 1 Users
|
| |
How to generate a report of the locks in a database with table names? The report can be obtained for specific SPIDs.
|
| |
| |
| |
|
Generate table admin report | SQL Server 7.0, SQL Server 6.5 and earlier | Advanced /
Umachandar | 5074 since
8/11/2000 12:11:06 PM |
By 1 Users
|
| |
How to generate a report on number of rows, size of a table using sp_spaceused system SP |
| |
| |
| |
|
Get size in bytes of SP, View, Trigger, UDF or Rule | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Joseph Gama | 5784 since
9/12/2003 2:18:15 PM | Unrated
|
| |
This UDF and its equivalent stored procedure will return the size of a stored procedure, view, rule or user defined function in bytes . |
| |
| |
| |
|
Grant execution | SQL Server 2000 | Intermediate /
Observer123 | 3480 since
11/18/2004 11:34:34 AM | Unrated
|
| |
To give execute right on stored procedures and functions in database |
| |
