| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Correct Zip and Zip+4 | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Sean P. O. MacCath-Moran | 3499 since
2/22/2007 6:39:46 AM | Unrated
|
| |
Updates malformed zip and zip + 4 to correct values.
- replaces leading zeros when dropped from begining of line
- drops zip4 and dash when zip4 not included
- replaces empty or non-sensical values with null |
| |
| |
| |
|
Create an Access database, Excel, etc from TSQL using ADOX | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Joseph Gama | 11547 since
9/12/2003 2:20:57 PM |
By 1 Users
|
| |
This SP will create an Access database from TSQL using ADOX.
Instead of Access, the Provider can be changed so that it will create *any* kind of database from DBase 3, Oracle, Excel, etc...
|
| |
| |
| |
|
CSV to a result set | SQL Server 7.0, Other | Advanced /
Siddeswara Rao Yadalla | 5251 since
3/12/2002 7:10:05 PM | Unrated
|
| |
Converts a CSV string to a result set. This does not parse or loop through the CSV string to convert it. |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
CSV to Table V2.0 | SQL Server 2000 | Intermediate /
Conradude | 5210 since
8/27/2004 3:59:32 AM | Unrated
|
| |
Converts CSV string to SQL Table.
Works with Text and not limited to 8000 characters.Great for Joins and "Bulk Inserts" |
| |
| |
| |
|
Data Scriptor (INSERT Generator) | SQL Server 2000, SQL Server 7.0 | Advanced /
Joseph A. De Guzman | 66661 since
3/8/2006 9:46:23 AM |
By 4 Users
4 Excellent Ratings
|
| |
This script backs up all the data from your database into a SQL script. (ScreenShot) |
| |
| |
| |
|
Data Scriptor v1.01 | SQL Server 2000, SQL Server 7.0 | Advanced /
Joseph A. De Guzman | 4639 since
3/9/2006 1:40:28 PM | Unrated
|
| |
This is an improvement from the previous script Data Scriptor script that I uploaded here. It still generates the INSERT statements for your data but this time it disregards image data types from the insertion. Improvement on the names of the fields and t ...(description truncated) |
| |
| |
| |
|
 dbupgrade.tar.Z | Oracle | Advanced /
Stéphane Faroult | 2306 since
7/13/2000 12:03:52 AM | Unrated
|
| |
Check and correct schema discrepancies between databases - a utility designed and developed by Simon Maxen, © 1999 Martin Wilkinson. |
| |
| |
| |
|
 DTSRun Utility | SQL Server 2000 | Intermediate /
Karthikeyan Rajendran | 7576 since
10/26/2007 10:21:32 AM |
By 1 Users
|
| |
Code Generation to Run a DTS Package in Command Prompt |
| |
| |
| |
|
Export to Text file | Other | Intermediate /
RuanDV | 4932 since
3/11/2009 11:24:42 AM | Unrated
|
| |
Export a query data to a text file on the SQL Server |
| |
| |
| |
|
Find differences in objects with scripting compoents in two different SQL Server databases | SQL Server 2000, SQL Server 7.0 | Advanced /
Philip Leitch | 5304 since
7/4/2003 12:46:10 AM |
By 1 Users
|
| |
When trying to syncronise databases it is often hard to work out what is different. This procedure detects differences in views, procedures, functions, default values, primary keys, etc. It is up to you to then fix these differences, but at least you know ...(description truncated) |
| |
(ScreenShot)
