| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Function formats number 1000 to alphanumeric 1.000 | Oracle | Intermediate /
Stephan Rechberger | 5421 since
9/14/2005 6:35:13 AM | Unrated
|
| |
PL/SQL-Function formats a number to a string with points at the thousends place 1000 = 1.000 |
| |
| |
| |
|
Generating random values using RAND function.sql | SQL Server 7.0 | Intermediate /
Umachandar | 7919 since
7/13/2000 10:23:45 PM |
By 1 Users
|
| |
Generate random values using RAND & NEWID function |
| |
| |
| |
|
German money format | Oracle | Beginner /
Kevin O'Neill | 5441 since
5/1/2002 9:41:31 AM | Unrated
|
| |
In working on a website in Germany I had to display the dollar amounts like 12,23 so this will do the trick |
| |
| |
| |
|
How SQL Server stores the datetime value in 8 bytes | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 9350 since
7/29/2000 9:58:12 PM |
By 2 Users
|
| |
Ever wondered how SQL Server stores the datetime value in 8 bytes. Well, this code shows how to decode the values using simple mathematical operations |
| |
| |
| |
|
 Hyperbolic and trigonometric functions for SQL Server 2000 | SQL Server 2000 | Beginner /
Joseph Gama | 4069 since
7/25/2002 5:34:20 AM | Unrated
|
| |
This is a collection of hyperbolic and trigonometric functions (UDF’s). |
| |
| |
| |
|
Increment Sequences | Oracle | Advanced /
Andy Archer | 3808 since
10/22/2004 5:51:39 PM |
By 2 Users
|
| |
Here is a PL/SQL stored procedure that lets you bump up nextval for a specific sequence, or for all sequences, in a schema. Useful for getting around sequence caching issues on instance rebuilds. Uses EXECUTE IMMEDIATE. |
| |
| |
| |
|
 ISNUMERIC is not “ALL DIGITS” | SQL Server 2000 | Advanced /
Jeff Moden | 17780 since
6/4/2006 6:01:00 AM |
By 5 Users
4 Excellent Ratings
|
| |
There are many cases where you need to ensure that the string data you are working with includes only numeric digits. Most Developers will use the built in ISNUMERIC function to make such a check. Here’s why that’s a bad idea and what to do ab ...(description truncated) |
| |
| |
| |
|
Minimum value | SQL Server 7.0, SQL Server 6.5 and earlier, Informix
, Oracle, Other | Beginner /
Umachandar | 4799 since
7/25/2000 8:48:26 PM |
By 2 Users
2 Excellent Ratings
|
| |
Find the minimum value in 3 columns |
| |
| |
| |
|
Modulus of floating point numbers | SQL Server 7.0, SQL Server 6.5 and earlier, Informix
, Oracle, Other | Beginner /
Umachandar | 3521 since
7/25/2000 8:49:11 PM | Unrated
|
| |
How to find modulus of floating point numbers. This one doesn't calculate the real modulus but this script just demonstrates few techniques. Also contains a sample to find the values before & after the decimal point in a decimal value. |
| |
| |
| |
|
Numbers from String | SQL Server 2000 | Advanced /
Jeff Michelson | 4591 since
12/30/2003 3:53:21 PM |
By 1 Users
|
| |
This code returns only the numbers from a submitted string. |
| |
