Optimized HexToSMALLINT

An optimized function for converting a HEX string into a SMALLINT. Built for being faster then other HexToDec converters.If there is any faster function to do this conversion, I am intrested of using it instead.

2006-10-11 (first published: )

114 reads

HexToINT

An optimized function for converting a HEX string into a INT. Built for being faster then other HexToDec converters.Slightly slower then HexToSMALLINT.If there is any faster function to do this conversion, I am intrested of using it instead.

2005-05-04 (first published: )

248 reads

Blogs

Daily Coping 26 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Rowcount estimates when there are no Statistics

By

When you don't have statistics, what does SQL use to calculate the estimated number...

Synapse Analytics and .NET for Apache Spark Example 4 - JOINS

By

This is a bit of a longer one, a look at how to do...

Read the latest Blogs

Forums

Balance is not calculating correctly,when date get change in transection.

By akhterhussain80

Below is data in which two different date are coming,01/19/2021 and 01/18/2021 , Date...

Accessing a RESTORING database for test refresh

By Pete Bishop

I have a requirement whereby testers on ServerA need a copy of the production...

How to get value portion key to every rn from 1 to 3 row on one row?

By ahmed_elbarbary.2010

I need to get value portion key to every 3 row on one row...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers