| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Get SQL Table Size - Table and Index Space - Row Count | SQL Server 2000, SQL Server 7.0 | Intermediate /
Zxtreme | 76762 since
7/30/2003 11:46:07 PM |
By 12 Users
8 Excellent Ratings
|
| |
This Script will return the row count and the amount of disk space that each table uses within a specifed database.
When returning total disk space used, it breaks it up into 3 categories...
1. The amount used by data
2. The Amount used by indexes
3. ...(description truncated) |
| |
| |
| |
|
 Multiple VALUES insert | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Fernando Pires | 179566 since
9/1/2004 4:45:50 AM |
By 12 Users
8 Excellent Ratings
|
| |
Use this little trick to INSERT MULTIPLE row values instead of using multiple INSERT statements to improve performance and typing. |
| |
| |
| |
|
spObjectPermissions | SQL Server 7.0 | Advanced /
John C Kirwin | 18683 since
2/12/2001 8:07:39 PM |
By 7 Users
7 Excellent Ratings
|
| |
Stored Procedure to query object permissions for specified user |
| |
| |
| |
|
 SQL Server 7.0 Stored Procedure Decryptor | SQL Server 7.0, SQL Server 6.5 and earlier, Other | Beginner /
David Daniels | 21082 since
8/9/2000 11:33:05 PM |
By 7 Users
7 Excellent Ratings
|
| |
Decrypts Encrypted SQL 7.0 Stored Procedures :) I love feedback so please send me an email with your comments and whatnot. Also, please rate this as you see fit |
| |
| |
| |
 |
Create Calendar in T-SQL | SQL Server 2000, SQL Server 7.0 | Advanced /
Jeff Moden | 11750 since
8/15/2007 11:22:32 AM |
By 8 Users
7 Excellent Ratings
|
| |
Creates a simple calendar output (single result set) similar to the screen shot. Can be 1 month or up to 179 years of months. (Sorry, previous screen shot didn't "take".) (ScreenShot) |
| |
| |
| |
|
SQL Statement that will list all the tables, columns, and datatypes in a Database alphabetically | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
David Drake | 10864 since
12/1/2000 7:26:26 PM |
By 8 Users
7 Excellent Ratings
|
| |
This SQL Statement works great for comparing two versions of the same database to determine the table differences. This SQL statement will list all the tables, columns, and datatypes for a SQL 6.5 or SQL 7.0 database and sort the resultset by tablename. I ...(description truncated) |
| |
| |
| |
|
Stored Procedures - send anonymous email over smtp | SQL Server 2000 | Intermediate /
Pange | 57687 since
5/7/2003 10:06:25 AM |
By 8 Users
7 Excellent Ratings
|
| |
This SP sends an email over SMTP with SQL Server 2000!
It need's enough rights and "CDO for Windows 2000"! |
| |
| |
| |
|
update one table with another table's data, with one SQL statement | Oracle | Intermediate /
Andy Archer | 82636 since
7/3/2006 12:25:52 PM |
By 8 Users
7 Excellent Ratings
|
| |
The example SQL and narrative illustrate how to update a column in one table with data from another table via an Update statement with a subquery. Merge example also included. |
| |
| |
| |
|
Create T-SQL Cursor Code For any Table | SQL Server 2000, SQL Server 7.0 | Advanced /
Limbo | 40161 since
3/9/2003 3:19:39 PM |
By 9 Users
7 Excellent Ratings
|
| |
Got tired of hand coding all that T-SQL cursor code so I created this to create the shell template for me.
Just choose any table you want to create a template for to process the records using a cursor. |
| |
| |
| |
|
Lie Finder database | Oracle | Beginner /
Ahmed Sumair | 9333 since
12/28/2002 2:30:59 PM |
By 9 Users
7 Excellent Ratings
|
| |
"hiiiii.....^CoolnGunius^...i think we have chatted before...can u remind
me ur good name plz"
1.Ever faced that situation?
2.do u have a bunch of friends?
here comes a database for all users who chat regularly OR have a number of friends!!!
This databse ...(description truncated)(ScreenShot) |
| |
(ScreenShot)
(ScreenShot)
