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: )

363 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: )

240 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: )

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2006-11-09 (first published: )

1,137 reads

Blogs

How I Built RAG for My Accounting App on Bedrock and pgvector

By

The first version of my accounting assistant could not find a single purchase of...

Why AI isn’t paying off yet, and what to invest in first

By

Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...

Flyway Tips: Analytics Platforms (Snowflake and Databricks)

By

I’m really excited about some growth in Flyway support. I’ve been asking about this...

Read the latest Blogs

Forums

Pay for Performance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Pay for Performance, which is...

Slow - Linked server query

By krypto69

Hi I have this slow query that is pulling data from a linked server....

Too Many Choices

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Too Many Choices

Visit the forum

Question of the Day

Too Many Choices

I have a table, dbo.MasterBrands, with this data:

BrandID OfficialName
1       Samsung
2       Apple
3       Microsoft
4       Adidas
5       Coca-Cola
I run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel')
FROM dbo.MasterBrands;

See possible answers