| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Climb_Every_Mountain | SQL Server 2000, SQL Server 7.0 | Beginner /
Philip Leitch | 5131 since
12/8/2005 5:02:45 AM |
By 1 Users
|
| |
This procedure will allow you to search for a string within ALL columns of ALL tables within 1 database, or within ALL databases on SQL server. |
| |
| |
| |
|
 Code stored in Binary/Text files instead in Stored Procedures-SQL SERVER | SQL Server 2000 | Advanced /
Raghavendra Narayana | 21983 since
9/26/2003 3:48:29 AM |
By 7 Users
4 Excellent Ratings
|
| |
The base idea of this article is to extend the boundary of SQL Server by introducing Code/part of code stored in ASCII/Binary/other file format in same/different server. The code of the Stored Procedures or User Defined Functions need not to reside only i ...(description truncated) (ScreenShot) |
| |
| |
| |
|
 Compare DB's | SQL Server 7.0 | Intermediate /
Pieter Jansen van Vuuren | 9061 since
10/22/2001 9:48:26 AM | Unrated
|
| |
An update of the code submitted by Razvan Petrescu
Made a bit more flexible by using variables for the Databases so you can compare any two db's on your server without changing the sp. |
| |
| |
| |
|
Compare two different databases | SQL Server 6.5 and earlier | Intermediate /
Umachandar | 17246 since
8/11/2000 11:29:32 AM |
By 3 Users
2 Excellent Ratings
|
| |
How to compare two different databases (on same server or different servers) & obtain a list of differences |
| |
| |
| |
|
Connecting to Sqlserver from linux platform by Rohit D'souza BrandCoder | SQL Server 2000 | Advanced /
rohit d'souza | 6711 since
5/23/2008 1:09:17 PM |
By 1 Users
|
| |
it shows how to configure tds on linux box |
| |
| |
| |
|
Count occurrences of a string in all SPs in db | SQL Server 6.5 and earlier | Intermediate /
Umachandar | 5066 since
8/11/2000 12:08:12 PM |
By 1 Users
|
| |
How to count occurrences of a string in all SPs in a database |
| |
| |
| |
|
Create a device file | SQL Server 6.5 and earlier | Intermediate /
Umachandar | 5449 since
8/11/2000 11:30:36 AM | Unrated
|
| |
How to create a device file |
| |
| |
| |
|
Create database using an on-demand task | SQL Server 6.5 and earlier | Intermediate /
Umachandar | 5951 since
8/11/2000 11:31:12 AM | Unrated
|
| |
Create database using an on-demand task that can be used by all users. This stored procedure can be used to create a database by just providing a name or optional size info. The pwdcompare function is undocumented & is used to password protect the SP. |
| |
| |
| |
|
Cross tab Query | SQL Server 2000 | Intermediate /
Anees Ahmed | 6768 since
6/5/2003 2:20:12 AM |
By 1 Users
|
| |
This Example Explains how Cross tab can Avoid use of Cursors.Cross Tab is Really Effetive in Requirements where your Rows have to be moved to Columns based on a Condition.Here this procedure calcualtes the sales in this format yesterday,today,this week,th ...(description truncated) |
| |
| |
| |
|
Cross tab Querying. | SQL Server 2000 | Intermediate /
Anees Ahmed | 5758 since
6/5/2003 2:20:57 AM | Unrated
|
| |
This Example Explains how Cross tab can Avoid use of Cursors.Cross Tab is Really Effetive in Requirements where your Rows have to be moved to Columns based on a Condition.Here this procedure calcualtes the sales in this format yesterday,today,this week,th ...(description truncated) |
| |
(ScreenShot)
