| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 TSQL Encryption TEA, RC4, Vigenere, Caesar, XOR | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier, Other | Intermediate /
Joseph Gama | 12066 since
6/17/2003 11:23:16 PM |
By 7 Users
6 Excellent Ratings
|
| |
Encrypt fields with these stored procedures and functions: TEA (new variant), TEA, RC4, Vigenere, Caesar, XOR, XOR8 for SQL Server This is a collection of stored procedures and encryption functions (UDF's) in TSQL.<BR> |
| |
| |
| |
|
UDF Luhn's formula-credit card number validation | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier, Other | Intermediate /
Joseph Gama | 11253 since
7/11/2003 2:22:57 PM |
By 2 Users
2 Excellent Ratings
|
| |
This UDF will validate a credit card number using Luhn's formula.For example 49927398716 will return 1:<BR>print dbo.luhn('49927398716')<BR>print dbo.luhn(49927398716)<BR>1<BR>1<BR><BR><BR>based on:<BR>Credit cards, validation and ...(description truncated) |
| |
| |
| |
|
 user restriction | SQL Server 2000 | Intermediate /
Jesse Leon | 3646 since
3/14/2003 11:43:46 AM |
By 1 Users
|
| |
I had a need for a script that was available to specific users but not available to anyone but them (inclucing sa). With this script you can assign the user and even if another user is assigned access it will stil prevent them from running it. |
| |
| |
| |
|
Validate SA ID Number | SQL Server 2000, Other | Intermediate /
RuanDV | 6297 since
1/18/2009 9:19:30 AM | Unrated
|
| |
This Stored Procedure can validate the South African ID number to say if it is valid |
| |
