| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 A right function for Oracle | Oracle | Beginner /
barkýn ünüulu | 41999 since
9/27/2007 4:13:24 AM |
By 2 Users
|
| |
The purpose of this tiny code snippet is to build a right function for Oracle which is used commonly in SQL Server. |
| |
| |
| |
|
Add a row at a specified position in a identity column | SQL Server 2000 | Intermediate /
Developer142 | 6188 since
9/2/2008 4:10:44 PM | Unrated
|
| |
Add a row at a specified position in a identity column |
| |
| |
| |
|
Age exactly edad exacta | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier, Informix
, Oracle, Other | Intermediate /
Alejo Carrilllo | 4706 since
1/7/2010 9:08:25 AM |
By 1 Users
|
| |
Devuelve la diferencia entre fechas
Result the diference between dates |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
All Tables and Columns | SQL Server 2000, SQL Server 7.0 | Advanced /
marisol gonzalez | 22927 since
7/28/2003 5:06:27 PM |
By 4 Users
|
| |
Store Procedure that display all tables and columns, type, length for any database. |
| |
| |
| |
|
An Easy way to Restore a DB | SQL Server 2000, SQL Server 7.0 | Advanced /
marisol gonzalez | 14231 since
7/31/2003 10:31:58 AM |
By 1 Users
|
| |
Restore any Data Base from ver 7.0 to 2K and viceversa |
| |
| |
| |
|
Asigns or revokes permission on user, or nt account on tables or store procedures | SQL Server 2000, SQL Server 7.0 | Advanced /
marisol gonzalez | 10001 since
7/31/2003 12:33:56 PM |
By 1 Users
|
| |
Asigns or revokes permission on user, or nt account on tables or store procedures for any data base |
| |
| |
| |
|
Attaching Multiple Database Files | SQL Server 2000, SQL Server 7.0 | Intermediate /
detanto | 16708 since
2/8/2003 4:42:37 AM |
By 2 Users
|
| |
This Stored Procedure will Attach Multiple SQL Server Database Files that have *.mdf or *.ldf extension |
| |
| |
| |
|
 Auto ID Generate | SQL Server 2000 | Beginner /
Asif Shahzad | 20352 since
1/25/2004 2:23:59 PM |
By 3 Users
2 Excellent Ratings
|
| |
This is very simple personal auto ID generator procedure and return VARCHAR value but first it check existing values that u can insert in VARCHAR field of ur TABLE. Thanks |
| |
| |
| |
|
BinToString | SQL Server 2000 | Advanced /
Bruce Donohue | 14419 since
11/20/2002 12:20:27 PM |
By 2 Users
|
| |
The purpose of this SQL function is to convert a binary value to a formatted string.
|
| |
| |
| |
|
Breaking a table into pages | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier, Oracle | Intermediate /
MstrControl | 66256 since
4/4/2003 11:08:14 AM |
By 3 Users
2 Excellent Ratings
|
| |
Reading the paging technique writen by Marcio Coleho here on PSC, I found a little flaw in the method.
Althought the code did break the table into pages, it didn't bring them in the correct order, if you want to use other field than PK.
I fixed this littl ...(description truncated) |
| |
