| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 OpenRowSet w/Parameters | SQL Server 7.0, SQL Server 6.5 and earlier, Other | Advanced /
Louis Davis | 50051 since
12/13/2000 9:10:33 PM |
By 9 Users
7 Excellent Ratings
|
| |
Steps to use parameters with the OPENROWSET function. |
| |
| |
| |
|
 Procedure to Export/Import Images In/From SQL SERVER | SQL Server 7.0 | Advanced /
Eli Leiba | 52243 since
6/27/2002 7:16:46 AM |
By 9 Users
7 Excellent Ratings
|
| |
the procedure is used as an Interface to the TextCopy Utility supplied with SQL SERVER in order to simplify handling of BLOBS (images/docs) |
| |
| |
| |
|
 sp_GrantPermissions | SQL Server 7.0, SQL Server 6.5 and earlier | Advanced /
John C Kirwin | 12131 since
1/8/2001 3:47:27 PM |
By 9 Users
7 Excellent Ratings
|
| |
Grants Select, Insert, Update, Delete, and Execute permissions to all stored procedures and user defined tables and views. |
| |
| |
| |
|
SQL CALENDAR | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Advanced /
John Overton | 34502 since
9/20/2002 3:01:38 PM |
By 11 Users
7 Excellent Ratings
|
| |
UPDATED:Produces Full Calendar for each Month in a Year. Just pass year as an integer. Let me know if it proves useful. Call it Like:
Execute Calendar 2002 |
| |
| |
| |
|
nth largest/smallest from a table | SQL Server 7.0, SQL Server 6.5 and earlier, Informix
, Oracle, Other | Intermediate /
MuraliKrishna Vedagiri | 20466 since
12/18/2001 12:22:58 AM |
By 5 Users
6 Excellent Ratings
|
| |
To find Nth largest and Smallest 'value'(Numbers) from a Table. |
| |
| |
| |
|
Change all table owners in a flash | SQL Server 7.0, Other | Intermediate /
James Travis | 15802 since
2/4/2002 6:44:38 AM |
By 6 Users
6 Excellent Ratings
|
| |
To quickly change the owner of all the tables in a database. |
| |
| |
| |
|
create a word document from a T-SQL SP | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 23294 since
8/11/2000 11:24:01 AM |
By 6 Users
6 Excellent Ratings
|
| |
How to create a word document from a T-SQL SP |
| |
| |
| |
|
Pivot Data based on Unknown Field Items | SQL Server 7.0 | Advanced /
James Travis | 20134 since
7/9/2001 9:26:15 PM |
By 6 Users
6 Excellent Ratings
|
| |
I was posed a question to pivot data on a column without knowing exactly what values exist. |
| |
| |
| |
 |
SQL*Plus "Pig" game | Oracle | Advanced /
Andy Archer | 3905 since
2/8/2013 1:45:28 PM |
By 6 Users
6 Excellent Ratings
|
| |
This is a two-player adaptation of the American folk game Pig. It's fun and fast. You'll have a blast! (ScreenShot) |
| |
| |
| |
|
Get All Tables Columns List in the Print Format style | SQL Server 2000, SQL Server 7.0 | Intermediate /
InnerBrains | 6444 since
9/12/2002 4:32:58 PM |
By 7 Users
6 Excellent Ratings
|
| |
This is code is used to get the All tables Fields information like Filed name, length,type and nullable or not |
| |
(ScreenShot)
