RC4 encryption/decryption with SQL Server
The first function is used to initialize the seed for the RC4 algorithm (second function), which does the encrypting/decrypting.
2007-08-29 (first published: 2007-02-12)
1,472 reads
Peter Larsson
Splitting strings
There are many split-functions out there. This is very fast because there is only two string manipulation functions involved, and not per-part string manipulation.
2007-08-28 (first published: 2007-02-12)
488 reads
PARSENAME Enhancement
The ParseName function is very useful for getting parts out of a string of characters between delimiters. But a limitiation is that you only can get four parts out, and the function only accepts dots as delimiters.The function I have written below overcomes that limitations, and add a new feature to enable "from left" and […]
2007-08-27 (first published: 2007-02-12)
329 reads
Fetching Ordinal number text
Interested in getting the ordinal number as text?You know, 1st, 32nd and so on?Have a look at this script.peso@developerworkshop.net
2007-04-05 (first published: 2007-03-02)
203 reads
CHECKSUM replacement for IMAGE
As we all know, BINARY_CHECKSUM ignores columns of data type IMAGE.This code is 100% compatible with MS original. That is, the result is identical.You can use it "as is", or you can use it to see that MS function does not produce that unique values one could expect.
2007-02-15 (first published: 2006-08-24)
203 reads
CHECKSUM replacement for TEXT
As we all know, BINARY_CHECKSUM ignores columns of data type TEXT.This code is 100% compatible with MS original. That is, the result is identical.You can use it "as is", or you can use it to see that MS function does not produce that unique values one could expect.
2007-02-13 (first published: 2006-08-24)
186 reads
MIME64 Encoder and Decoder written in T-SSQL
Here is a MIME64 encoder function written entirely in T-SQL!© 2006 Peter Larsson, Developer Workshop, all rights reservedAs long as the copyright notice is visible within the function declarationand you include a note in the documentation of your system that thesefunctions are written by me, you may use these functions for free of charge.If you […]
2006-11-09 (first published: 2006-06-15)
1,074 reads
Pivot Table Recordset for SQL 2000
This is the basic structure of how to dynamically create a pivot table recordset for SQL 2000. In this example, I am using SUM, but it could just as easy be COUNT or any other aggregate function.
2006-05-26 (first published: 2006-05-08)
1,875 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Jelambar Baru Raya,Telp/Wa 0821.3111.159
Jl. Jelambar Baru Raya No.53 C, Jelambar, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah...
BCA KCP Puri Kembangan TLP/WA 0821-697-7701
Jl. Kembangan Raya No.3A, Kedoya Sel., Kec. Kb. Jeruk, Kota Jakarta Barat, Daerah Khusus...
BCA KCP Pademangan Tlp (+62 821°3111°179
Gg. 21 dan 22 No.1, Pademangan Tim., Kec. Pademangan, Jkt Utara, Daerah Khusus Ibukota...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers