| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Parul Khanna | SQL Server 2000 | Intermediate /
Parul Khanna | 4031 since
11/16/2006 7:25:47 AM |
By 1 Users
|
| |
This function will calculate the number business days in between the two given dates. |
| |
| |
| |
 |
 reset a sequence without dropping and re-creating it | Oracle | Advanced /
Andy Archer | 3044 since
10/6/2005 12:24:37 PM |
By 3 Users
3 Excellent Ratings
|
| |
PL/SQL stored procedure. This small, commented proc uses EXECUTE IMMEDIATE to reset a sequence without dropping and re-creating it (which would impact dependent objects). |
| |
| |
| |
|
Second biggest value in a column | Oracle | Advanced /
VsVarun | 3160 since
9/10/2007 2:02:07 PM | Unrated
|
| |
It displays the second maximum value in a column |
| |
| |
| |
|
Simple Calculator With Graphic Mode | Other | Beginner /
ali selman aydin | 2533 since
6/27/2007 11:51:52 AM | Unrated
|
| |
My code can calculate some mathemathical processes.
But now, it's only Turkish. In 2 days,I'll complete english version |
| |
| |
| |
|
 T-SQL Random Numbers at their best | SQL Server 7.0 | Intermediate /
Harinatha Reddy Gorla | 4096 since
2/27/2002 7:31:39 AM |
By 3 Users
2 Excellent Ratings
|
| |
There may be several cases where we have to deal with random numbers.
The follwong T-SQL batch will show how to achieve this functionality.
|
| |
| |
| |
|
Toggle Bit Function | Other | Beginner /
Lewis E. Moten III | 3580 since
6/3/2002 2:22:45 PM |
By 3 Users
|
| |
Toggle bit fields with a small line of code. |
| |
| |
| |
|
udf_Check_For_Juvenile | SQL Server 7.0 | Advanced /
Jacob Kornit | 3072 since
5/31/2002 3:33:10 PM | Unrated
|
| |
Check age to see if it is a juvenile or adult. |
| |
| |
| |
|
Valid Number Function | SQL Server 2000 | Intermediate /
aguilar303 | 6121 since
8/14/2003 1:00:49 PM | Unrated
|
| |
Converts any value passed to the function to a valid number.
Avoids having to check for nulls or other non-numeric values at the client application or when passing values to other functions.
Can you think of easier or better ways of doing this? I would be ...(description truncated) |
| |
