| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Document SQL Server 1.01 | SQL Server 2000 | Intermediate /
PeterTT | 4002 since
6/19/2003 12:02:12 PM | Unrated
|
| |
Re-Submitted as zip to try and save the format, I am sure you will let me know if it doesn't!
This script will document (PRINT) tables
Tables (with Triggers), Stored Procedures, Views and User Defined Functions
Modified: 18 June 2003
ADDED MORE COMMENTS ...(description truncated) |
| |
| |
| |
|
Dynamic Database Driven Marquee | SQL Server 7.0 | Intermediate /
Anthony Lange | 4228 since
4/24/2002 6:55:37 AM | Unrated
|
| |
This code displays a dynamic Marquee with data from a MSSQL DATABASE. There are selection buttons allowing you to point to other tables.
Typically usefull in an industrial website to display data in a digital dashboard or just a web page. |
| |
| |
| |
|
 Dynamically Backup Analysis Services Cubes | SQL Server 7.0 | Beginner /
Ben McLean | 3926 since
7/2/2002 10:24:01 PM | Unrated
|
| |
Because we add new cubes to our analysis server all the time during development, i didn't want to have to manually setup a backup for each new cube. |
| |
| |
| |
 |
eight Oracle developer pitfalls | Oracle | Intermediate /
Andy Archer | 9447 since
11/15/2010 8:28:05 PM |
By 2 Users
|
| |
Write-up and examples: (1) NULL, (2) NOT IN, (3) inadvertent index suppression, (4) unexpected COMMIT, (5) TO_CHAR conversions, (6) SQLCODE and SQLERRM, (7) EXECUTE IMMEDIATE of SELECT INTO, and (8) initializing in DECLARE. |
| |
| |
| |
|
eight SQL*Plus tips | Oracle | Beginner /
Andy Archer | 9411 since
9/4/2012 3:10:51 PM |
By 3 Users
2 Excellent Ratings
|
| |
A short write-up: suppress "Input truncated" and SET echoing; see full text of DBMS_OUTPUT and LONG Selects; execute scripts with shorthand; edit session profile; save and reapply settings; see leading spaces on DBMS_OUTPUT. |
| |
| |
| |
|
Eliminate Duplicate Rows | SQL Server 2000 | Intermediate /
Praveen Vasudevan | 10272 since
1/4/2005 1:12:16 AM |
By 4 Users
4 Excellent Ratings
|
| |
Eliminates duplicate rows from a table using TSQL Statements. Does not require intermediate temporary tables or cursors or Identity columns. Can be achieved using the ROWCOUNT property. |
| |
| |
| |
|
Encrypt using XOR | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 5110 since
7/29/2000 9:54:42 PM | Unrated
|
| |
Functions to encrypt data in columns are not available in SQL Server (except undocumented ones that are risky to use & not supported). Here is one that shows how to do this using XOR. |
| |
| |
| |
|
Explictly Inserting data in Identity Field in MS SQL Server By Rohit D'souza | SQL Server 2000, SQL Server 7.0 | Intermediate /
rohit d'souza | 5670 since
5/31/2006 7:29:43 AM | Unrated
|
| |
Its teaches u a New concept |
| |
| |
| |
|
extract all server PL/SQL source code from the Data Dictionary | Oracle | Advanced /
Andy Archer | 5992 since
4/11/2006 3:54:15 PM | Unrated
|
| |
These four scripts extract all server proc and trigger PL/SQL source code for a schema from the Data Dictionary, spooling it to files for printing, searching, copying, compiling, etc. |
| |
| |
| |
|
Find all Full Text Catalogs on Server | SQL Server 2000, SQL Server 7.0 | Intermediate /
Brent Glover | 3210 since
6/23/2002 11:56:08 PM |
By 1 Users
|
| |
Display all Full Test catalogs on a given SQL server |
| |
