| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 executelargesql | SQL Server 2000 | Advanced /
Keith Henry | 7265 since
8/21/2003 5:35:07 AM | Unrated
|
| |
When building dynamic sql statments
sp_executesql can only handle up to 4000 chars
and exec up to 8000.
To handle up to 156000 use this sproc
|
| |
| |
| |
|
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. |
| |
| |
| |
|
 Find a string in Procedures, Triggers, Constraints, Defaults,Functions and Views-even between blocks | SQL Server 2000, SQL Server 7.0 | Intermediate /
Joseph Gama | 11237 since
2/21/2004 8:26:12 AM |
By 2 Users
|
| |
I want to thank James Travis for his original and excellent work and to Razvan Socol for alerting about a similar problem that led me to improve James' code.
The problem is that when searching for a word that is split between two 8kb blocks, James' code w ...(description truncated) |
| |
| |
| |
|
Find and edit foreign keys | SQL Server 7.0 | Intermediate /
T Runstein | 5803 since
7/5/2001 4:32:11 PM |
By 4 Users
3 Excellent Ratings
|
| |
Shows how to find foreign keys using system tables. Example changes an employee number in a main table while updating the number in all foreign tables where the employee number is found. I've added lots of comments. T Runstein |
| |
| |
| |
|
Finding No of Max values | Other | Advanced /
Kiran K Surve | 3553 since
12/17/2009 8:48:25 AM | Unrated
|
| |
To finding no of max values from a table.max function gives only one value, but this procedure gives top max no of values.I have created this procedure in sybase. U can check the procedure using same logic in other databse also |
| |
| |
| |
|
FTP SPROC | SQL Server 2000, SQL Server 7.0 | Intermediate /
Michael Down | 4812 since
10/16/2004 4:15:04 PM | Unrated
|
| |
This SProc allows MS SQL Server to download files via FTP through SQL and move the file to the desired location. |
| |
| |
| |
|
 Function to obtain Last Days of Months | SQL Server 2000, SQL Server 7.0 | Intermediate /
Webmaster For LifeInTheVine.Com | 5037 since
9/5/2003 1:43:28 PM |
By 1 Users
|
| |
This is a function that returns a table containing the last days of months in a specified number
of following years. |
| |
| |
| |
 |
GenerateJoins | SQL Server 2000, SQL Server 7.0 | Advanced /
Sherenato | 8135 since
7/20/2006 12:16:00 PM |
By 2 Users
|
| |
Generate complete joins. |
| |
| |
| |
|
Get All Columns and Type and Size | SQL Server 2000 | Advanced /
Keith McCormick | 4967 since
6/9/2003 9:28:36 AM |
By 2 Users
|
| |
This section of code returns the Name of the Column, The type of column, and the size of the column. |
| |
| |
| |
|
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 |
| |
