| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Creating XML in a Stored Procedure | SQL Server 7.0 | Intermediate /
The_Mat_in_the_Hat | 43949 since
10/9/2000 4:20:38 AM |
By 7 Users
3 Excellent Ratings
|
| |
Use a cursor in a stored procedure to create short XML string to output rather than recordsets.
Also included is a simple VB application (with source) that generates the SQL |
| |
| |
| |
|
 Data Encryption Function | SQL Server 2000, SQL Server 7.0 | Intermediate /
Jovick | 8918 since
6/9/2004 3:16:14 PM |
By 4 Users
4 Excellent Ratings
|
| |
This function returns an encrypted varchar string of the parameter string passed to it. To un-encrypt it simply just run the encrypted string back through it. I have found that this is a good way to store sensitive table data like passwords and human reso ...(description truncated) |
| |
| |
| |
|
DaysInMonth | SQL Server 2000 | Intermediate /
Karthikeyan Rajendran | 4374 since
3/13/2007 12:39:01 PM | Unrated
|
| |
To obtain the number of days in a month just by providing the month and year |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
 DB Growth on a daily basis | SQL Server 2000, SQL Server 7.0 | Intermediate /
Alagappan SL | 4688 since
11/24/2002 11:12:22 PM |
By 2 Users
|
| |
Stores the Database Size and Growth on a daily basis to a table. |
| |
| |
| |
|
DB/Table/Index Details | SQL Server 2000 | Intermediate /
Adonis Villanueva | 9279 since
11/20/2002 5:47:40 PM |
By 3 Users
|
| |
This script will display certain details of all databases within a server. It loops through all user databases within a server, then loops through all the tables within the database. For each table it displays index details. |
| |
| |
| |
|
Delete a row from a position in identity column | SQL Server 2000 | Intermediate /
Developer142 | 4093 since
9/2/2008 4:11:04 PM | Unrated
|
| |
Delete a row from a position in identity column |
| |
| |
| |
|
Dias Laborales Working Days | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier, Other | Intermediate /
Alejo Carrilllo | 4883 since
1/8/2010 8:53:05 AM |
By 1 Users
|
| |
Obtiene los dias laborales entre dos fechas
get working days between two dates |
| |
| |
| |
|
Discovering a table size | SQL Server 7.0 | Advanced /
Dennes Torres de Oliveira | 35278 since
1/2/2001 10:17:39 PM |
By 10 Users
6 Excellent Ratings
|
| |
This procedure help you to discover what will be the table size with the records, so you can plan the database size. |
| |
| |
| |
|
Example for Creating html tables from stored procedure | SQL Server 7.0, SQL Server 6.5 and earlier, Informix
, Oracle, Other | Advanced /
Fernando Pires | 10679 since
1/22/2001 9:23:26 AM |
By 2 Users
|
| |
Creating a html table from a stored procedure. Essentialy what you do is you embed html code whith the fields. |
| |
| |
| |
|
Examples for Structured Data Variable in pl/sql | Oracle | Intermediate /
Eli Leiba | 5480 since
11/17/2002 9:51:30 AM | Unrated
|
| |
examples to usage of RECORD , rowtype AND table
data structures |
| |
