| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Controlling wrap and line size | Oracle | Beginner /
Mike J Anderson | 12230 since
1/9/2002 8:13:02 PM |
By 1 Users
|
| |
If you use SQL Plus (yeeks) you can turn the wrapping lines off and set the line size so you can view the data more legibly.
The code below turns wrapping off and sets the line size to 1000 characters. |
| |
| |
| |
|
Convert Date Parts to Date | SQL Server 2000 | Beginner /
Mike J Anderson | 10384 since
6/30/2003 12:35:15 AM | Unrated
|
| |
Combine three fields (mm & dd & yyyy) into a single date field. |
| |
| |
| |
|
Convert RTF Data | SQL Server 2000, SQL Server 7.0 | Advanced /
Brijesh Tiwari | 7595 since
1/14/2006 7:42:13 PM | Unrated
|
| |
This code will convert any RTF data to normal string |
| |
| |
| |
|
Convert To Currency | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Advanced /
John Overton | 7763 since
10/30/2003 11:22:19 AM |
By 2 Users
|
| |
Quickly formats any number to currency. Adds commas(if applicable) and dollar sign. Very usefull if exporting dollar amount data to XML format. |
| |
| |
| |
|
 Convert to Julian date and Convert From Julian Date Functions | SQL Server 7.0 | Intermediate /
IvbNet | 58961 since
9/18/2001 2:54:01 PM |
By 6 Users
4 Excellent Ratings
|
| |
Convert to Julian date and Convert From Julian Date Functions
Your comment are welcome ,vote if you like.
Thanks
http://www.ivbnet.com |
| |
| |
| |
|
converting Decimal Value To Hexa Decimal Value Through UDF | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Venkata Krishnan K S | 8408 since
1/13/2006 8:11:40 PM | Unrated
|
| |
Converts Decimal Values To HexaDecimal Value Through UDF It Can Be Columns Of Table or Integer Values. |
| |
| |
| |
|
Converting HexaDecimal Value To Decimal Through UDF | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Venkata Krishnan K S | 8471 since
1/13/2006 8:11:46 PM | Unrated
|
| |
To Convert HexaDecimal Values in String Value To Decimal value. |
| |
| |
| |
|
Converting String values to float types | SQL Server 2000, SQL Server 7.0 | Advanced /
barkýn ünüulu | 14416 since
8/13/2005 6:24:04 AM |
By 1 Users
|
| |
The purpose of this function is to convert the numbers that are being imported from other data sources as character formats. For example sometimes some numerical data can be imported as follows: '121213,98'. This data can not be converted to float types e ...(description truncated) |
| |
| |
| |
|
Copy scriptable objects from one database to another | SQL Server 2000, SQL Server 7.0 | Advanced /
Philip Leitch | 5157 since
7/4/2003 12:34:33 AM | Unrated
|
| |
Makes the scriptable objects in one database match those of another. For example, all the Procedures, functions and views on one Development database can be moved to a live database via this script. |
| |
| |
| |
|
Copy text values | SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Umachandar | 7531 since
7/25/2000 8:34:38 PM | Unrated
|
| |
Copy text values from one table to another. This one demonstrates for a text value in a single row. |
| |
