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,435 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)
483 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)
321 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)
195 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)
191 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)
178 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,057 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,859 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers