| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 User Defined Function Intro | Other | Intermediate /
Lewis E. Moten III | 33240 since
3/3/2002 12:17:36 AM |
By 12 Users
9 Excellent Ratings
|
| |
Brief introduction to user defined functions with examples and benefits explained. |
| |
| |
| |
|
 Backup All Databases | SQL Server 7.0, SQL Server 6.5 and earlier | Advanced /
PHendryx | 38989 since
3/23/2001 9:12:15 AM |
By 13 Users
9 Excellent Ratings
|
| |
This script was written because I have a server with about 115 client databases on it. It was a rather hard task to try to backup all of them by hand and I didnt want to spend a few grand on a good piece of backup software. Basicly, this script just loops ...(description truncated) |
| |
| |
| |
|
 Airport Database | Oracle | Intermediate /
Jim Ellis | 27654 since
12/14/2001 4:02:39 PM |
By 15 Users
9 Excellent Ratings
|
| |
Database |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
Find a string in Procedures, Triggers, Constraints, Defaults, Functions, and Views | SQL Server 7.0, Other | Intermediate /
James Travis | 21681 since
2/20/2002 8:05:10 AM |
By 8 Users
8 Excellent Ratings
|
| |
Allow users to search thru objects for a value they are looking. This may be items that touch a specific table/view or items that need to be replaced. |
| |
| |
| |
|
Join the results of a stored procedure in T-SQL : A Clean Sample | SQL Server 7.0 | Intermediate /
Harinatha Reddy Gorla | 70386 since
2/19/2002 4:04:09 AM |
By 8 Users
8 Excellent Ratings
|
| |
There may be several instances where you have to join the results of a stored procedure with another query. Here's how to do it
|
| |
| |
| |
|
SQL Calendar (Updated) | SQL Server 2000 | Advanced /
John Overton | 17694 since
3/1/2003 10:06:29 AM |
By 8 Users
8 Excellent Ratings
|
| |
Displays complete calendar of any given year. Updated version of original code... Easy to alter to fit your needs.
Call--- Execute Calendar 2003 |
| |
| |
| |
|
Table/Data Size Reporter v2.1 | SQL Server 7.0, Other | Beginner /
MisterD88 | 5785 since
10/5/2001 8:02:17 PM |
By 8 Users
8 Excellent Ratings
|
| |
Script to report table sizes (datatypes and data) for all user tables in the database executed on. Formatted to < 80 chars wide, should print nicely on any printer in portrait mode. Tested on SQL 7.0 & 2000 only, although it might work on 6.x as
well. ...(description truncated) |
| |
| |
| |
|
UPDATED: Procedure to script your data (it generates INSERT statements for your existing data) | SQL Server 7.0 | Advanced /
Narayana Vyas Kondreddi | 27006 since
2/20/2001 2:38:38 AM |
By 8 Users
8 Excellent Ratings
|
| |
UPDATED with MORE features on 14th April 2001. This procedure generates INSERT statements using existing data from the given tables. Later, you can use these INSERT statements to generate the data. It's a kind of data scripting, just like scripting table ...(description truncated) |
| |
| |
| |
|
 FormatDate | SQL Server 7.0 | Intermediate /
Lewis E. Moten III | 49844 since
5/22/2002 4:35:10 PM |
By 9 Users
8 Excellent Ratings
|
| |
Dynamically convert a date to a user-defined format. (ScreenShot) |
| |
| |
| |
|
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 |
| |
(ScreenShot)
