| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 How to format a number to print with a specific number of decimal places. | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
MSchuch | 12174 since
4/8/2005 6:43:31 PM |
By 1 Users
|
| |
Formatting a number to print rounded off to a specific number of decimal places is quite easy and doesn't require a user defined function.
Formatting a number as a dollar amount is also easy.
These are handy for formatting output for XML.
If you like this ...(description truncated) |
| |
| |
| |
|
Int2GUID | Other | Intermediate /
Lewis E. Moten III | 5326 since
5/24/2002 6:08:45 PM | Unrated
|
| |
Datatype conversion to change integers to unique identifier datatypes. This
method is most useful when upgrading database schemas from using integers to
using guids. You will still be able to "read" values by eye to match old Integers with the new GUIDs. (ScreenShot) |
| |
| |
| |
|
 Integer to bits | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Sajid Ali Anjum | 2730 since
6/14/2006 4:38:49 PM |
By 1 Users
|
| |
Binary representation of any integer value(ScreenShot) |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
Leading Space | SQL Server 2000 | Advanced /
Jeff Michelson | 2802 since
11/4/2004 12:15:48 PM |
By 1 Users
|
| |
This function will left-pad any string. |
| |
| |
| |
|
Leading Zero | SQL Server 2000 | Advanced /
Jeff Michelson | 7346 since
11/4/2004 12:21:11 PM |
By 1 Users
|
| |
This function will return a string padded with leading zeros. This is useful for creating EDI files, or other bank-related documents that require zero padded numerics in a text file. |
| |
| |
| |
|
Left & Right pad decimal values with zeroes in character format.sql | SQL Server 7.0 | Beginner /
Umachandar | 7698 since
7/18/2000 8:39:26 AM |
By 3 Users
|
| |
How to pad decimal values with zeroes & to a fixed length for say exporting the data |
| |
| |
| |
|
LowerCaseFix | Oracle | Intermediate /
Ron Santillano | 3668 since
4/26/2002 12:02:06 AM | Unrated
|
| |
This script will recreate a table that has any lowercase columns. It will keep the data intact.
It is a function that needs to be called from a procedure. |
| |
| |
| |
|
Milliseconds | SQL Server 7.0, SQL Server 6.5 and earlier, Oracle | Beginner /
Mike J Anderson | 5926 since
8/31/2001 4:26:22 PM |
By 4 Users
2 Excellent Ratings
|
| |
Convert a Oracle date to milliseconds. |
| |
| |
| |
|
 Num2Guid Conversion Function | Other | Advanced /
Lewis E. Moten III | 8249 since
5/24/2002 7:23:12 PM |
By 1 Users
|
| |
Article describing how to convert a decimal to a guid format. Also goes into detail explaining how to convert to other base-N numbers such as a bitmask/binary, octet, trinary, hex, and more. Introduces the benefit of functions with a real-case scenario.(ScreenShot) |
| |
| |
| |
|
Pad String or Number w/ Char | SQL Server 2000, SQL Server 7.0 | Beginner /
Sean P. O. MacCath-Moran | 5037 since
2/13/2003 2:10:14 PM |
By 1 Users
|
| |
/*
Pad a string or a number with a specified character. For example, pad an integer set to 555 with a max set to six 0s and receive 000555; or pad a string set to 'Hello' with up to eight spaces and receive ' Hello'.
*/ |
| |
(ScreenShot)
(ScreenShot)
(ScreenShot)
