Peter Larsson


Technical Article

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 […]

You rated this post out of 5. Change rating

2007-08-27 (first published: )

311 reads

Technical Article

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.

You rated this post out of 5. Change rating

2007-02-15 (first published: )

176 reads

Technical Article

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.

You rated this post out of 5. Change rating

2007-02-13 (first published: )

173 reads

Technical Article

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 […]

5 (1)

You rated this post out of 5. Change rating

2006-11-09 (first published: )

1,018 reads

Blogs

Using Git Prune–#SQLNewBlogger

By

As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...

Microsoft Purview new data governance features

By

Starting last week is a rollout of the public preview of a new and...

SQL Database Administration: Not For Everyone (But Maybe It’s for You)

By

Let's get one thing straight: database administration isn't the most glamorous tech job out...

Read the latest Blogs

Forums

SSRS Expression IIF Zero then ... Got #Error

By danyeungw

Hello, Need some help for SSRS. The column % expression is =iif(sum(Fields!ColumnA.Value) = 0...

Insert using table unput

By Bruin

I have a table that I need to run off a different server\db and...

zero downtime deployments

By sqlguy80

Hello, We have azure MI business critical. active read/write, secondary read /only. from what...

Visit the forum

Question of the Day

Restoring the Resource Database

How can I restore a version of the Resource Database in SQL Server 2022?

See possible answers