| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Find the first of the Month | SQL Server 7.0, SQL Server 6.5 and earlier, Oracle, Other | Intermediate /
RObot X5 | 5444 since
10/11/2001 1:18:11 PM |
By 2 Users
|
| |
This is a crazy example of how to use the convert function to make a datetime out of 2 dates and a string. This is just a example. |
| |
| |
| |
|
 fnCharPad | SQL Server 2000 | Beginner /
Shane Lively | 4221 since
8/23/2002 12:07:35 PM | Unrated
|
| |
This is a user defined function that will left or right pad the passed in value with any given single character. Useful when prepping data for output.
USAGE:
SELECT dbofnCharPad('TEST','X',0,10)
result = 'XXXXXXTEST' |
| |
| |
| |
|
Format Phone Number Function | SQL Server 2000, SQL Server 7.0 | Intermediate /
Ysaias Portes | 10730 since
11/23/2005 8:42:53 AM | Unrated
|
| |
This simple function will format a 10 digits phone number (8001234567) into a nice looking formated phone number (800)123-4567. (ScreenShot) |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
FORMAT_AMOUNT | SQL Server 2000 | Advanced /
Daniel K Murphy | 5086 since
2/6/2004 4:09:22 PM | Unrated
|
| |
Formats a Number to a String, preserving the Leading and/or trailing zeros (decimal positions) as a function within SQL Server 2000 |
| |
| |
| |
|
Function For Reversing the String in Oracle | Oracle | Intermediate /
jtanwar | 7428 since
7/23/2002 5:04:58 AM |
By 1 Users
|
| |
For Creating the Reverse of the String Within the Oracle Database Using the Standard Utl_Raw Package Supplied With the Oracle. To Be Able to Use this Function You must have the Execute Permission To the UTL_RAW Package.
|
| |
| |
| |
|
Function to Convert Camel Case | SQL Server 2000 | Beginner /
Tom Bruinsma | 14054 since
2/21/2005 3:54:05 PM |
By 2 Users
2 Excellent Ratings
|
| |
I was in need of a function tht would make my column names a little more friendly to the user. I often use mixed case when creating field names. This function allowed me to make the display a little more friendly to the user. |
| |
| |
| |
|
HEX string value to int conversion.sql | SQL Server 7.0 | Beginner /
Umachandar | 5861 since
7/18/2000 8:44:06 AM |
By 1 Users
|
| |
Code to convert a hexadecimal value stored in a string to integer |
| |
| |
| |
|
Hex to Binary Converter | SQL Server 2000 | Advanced /
Shivanand Iyer | 8707 since
2/10/2006 6:22:12 AM | Unrated
|
| |
Converts Hexadecimal to Binary |
| |
| |
| |
|
How much table space was given to you? | Oracle, Other | Beginner /
Mike J Anderson | 3587 since
1/9/2002 8:20:42 PM | Unrated
|
| |
User Quotes shows you your space and how much was given to you. |
| |
| |
| |
|
How to connect SQL Server 7.0 to Informix | SQL Server 7.0, Informix
| Intermediate /
Artur Angielski | 35044 since
8/23/2000 8:35:17 AM |
By 3 Users
2 Excellent Ratings
|
| |
This article is providing information how to
connect your SQL Server database to Informix
database, and how to use queries exchanging data
between Informix and SQL. It also might be
helpfull, when you need connection to other ODBC
sources. |
| |
(ScreenShot)
