| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 sp_Base64EncodeStr | SQL Server 7.0 | Intermediate /
Lewis E. Moten III | 8921 since
12/2/2000 6:32:41 PM |
By 2 Users
2 Excellent Ratings
|
| |
This procedure demonstrates how to instantiate an OLE object.
I have used an ActiveX dll called
AspConv™ (provided in AspLib™) to encode text with Base64 encoding in this example.
The object must be registered on THE DATABASE SERVER (not to be ...(description truncated) |
| |
| |
| |
|
SQL Detect and or Delete Dups | SQL Server 2000 | Advanced /
Sean P. O. MacCath-Moran | 12311 since
10/25/2002 5:15:49 PM |
By 4 Users
3 Excellent Ratings
|
| |
/*
Hassle free locating / reporting or deletion of duplicate rows in a SQL table based on the uniqueness of a column or columns that the user provides with a few nifty hands off features.
Keywords: delete unique column record records
*/ |
| |
| |
| |
|
 Sql server backup file in zip Format. | SQL Server 2000 | Intermediate /
Joshy George | 4272 since
10/11/2006 3:28:09 AM | Unrated
|
| |
It is a sample C# (VS2005) application for creating Sql server backup file in zip Format. |
| |
| |
| |
|
sql2vss | SQL Server 2000 | Intermediate /
Daniel Salazar | 5634 since
10/7/2002 5:02:20 PM |
By 2 Users
2 Excellent Ratings
|
| |
Scripts a sql server 2000 database, all the objects, scripts, tables, indexes to a Visual Source Safe repository. |
| |
| |
| |
|
SQLDMO DB Attach Detach | SQL Server 7.0 | Intermediate /
Rick Winscot | 7738 since
1/8/2002 1:39:10 PM |
By 2 Users
|
| |
Explore attaching and detaching databases. SQLDMO is a great resource for database management - however, there are many undocumented facts. Such as, in the attach argument... the path must be a short file name (dos 8.3) - I have used the getshortname API ...(description truncated) |
| |
| |
| |
|
Trap error messages without sending to client | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 5515 since
8/11/2000 11:24:38 AM | Unrated
|
| |
SQL dmo example that shows how to trap error messages without sending to client |
| |
| |
| |
|
Use the methods on collections | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 5193 since
8/11/2000 11:26:07 AM |
By 2 Users
|
| |
SQLDMO - How to use collection ITEM methods |
| |
| |
| |
|
 vwColumnDescription | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Paco Leche | 8349 since
3/19/2007 1:27:40 PM | Unrated
|
| |
Return Column Descriptions |
| |
| |
| |
|
Web Frontend for SQL Server | SQL Server 2000, SQL Server 7.0 | Intermediate /
Sukalyan Chakraborty | 6740 since
4/15/2005 3:09:56 PM |
By 1 Users
|
| |
It is a web fontend from SQL Server. you can work with tables (create, delete, edit etc.), views and procedures and more. It has a good query builder. You can Attach/Detach, Backup/Restore, Export database also. (ScreenShot) |
| |
| |
| |
|
Write to Excel from T-SQL | SQL Server 2000, SQL Server 7.0 | Intermediate /
Peter Danailov | 16778 since
2/14/2003 5:46:47 AM |
By 6 Users
2 Excellent Ratings
|
| |
The module opens/writes into Excel files directly from SQL server. All the parameters of this module could be provided automatically. In this way the whole procedure could easily be put into SP, function, etc. |
| |
(ScreenShot)
