Convert a Positive Number To a Negative In SQL With a Spot of Bitwise Logic

Now this is something that I've seen asked a few times and it's always a question that gets a fair number of different answers. How do we go about converting a positive number to a negative, or the other way around? I'll give you my solution and it uses a little bit of bitwise logic.... Continue Reading →

May 24, 2018 3

The Arcane Science of Bitwise Logic and SQL Server

Bitwise logic, it seems is one of those ancient areas of computing that's only remembered by those old guys that have been kicking around for years. But what is it and how can we use it in SQL? Before we start looking at bitwise logic and the bitwise operators, we need to have a quick... Continue Reading →

Jul 7, 2017 4