Bitwise Logic In SQL Server

Kevin Feasel

2017-07-10

Syntax

David Fowler shows how to use bitwise logic in SQL Server:

Bitwise operators are operators that work on the individual bits of a value.  Let’s take a little look at the three bitwise operators that we’ve got in SQL server (there is actually a fourth but I’ll talk about that one another time) and hopefully things will start making a bit of sense.

Now let us never speak of this again…

Related Posts

Finding The Last Non-Null Value With Snowflake

Koen Verbeeck shows how two words makes solving a problem with Snowflake a lot easier than with SQL Server: Sometimes you need to find the previous value in a column. Easy enough, the LAG window function makes this a breeze (available since SQL Server 2012). But what if the previous value cannot be null? You […]

Read More

Concerns With DISTINCT

Anvesh Patel does not like DISTINCT: I am telling you personally that I hate the use of DISTINCT.DISTINCT used by those people, who are not sure about their data set or SELECT statement or JOINS.Whenever I get any query with DISTINCT, immediately I suggest to remove it. I agree with this sentiment about 85% of […]

Read More

Categories

July 2017
MTWTFSS
« Jun Aug »
 12
3456789
10111213141516
17181920212223
24252627282930
31