Five expressions flip a bit value in SQL Server without a CASE statement. This post runs Vinod Kumar’s four methods and the readers’ answers on SQL Server 2025, shows what each one returns for 0, 1 and NULL, and explains how to flip value of bit field data stored in an integer column.
SQL SERVER – How to Flip Value of Bit Field in SQL Server?
How do you flip bit field values from 0 to 1 and back? My favorite method is the ~ operator. Here is a short script that shows it.
SQL SERVER – Database Stuck in Restoring State
Is your database stuck in restoring state after you restored all backups? RESTORE DATABASE WITH RECOVERY brings it online. I show what to run and when.
Why Use Biml to Build SSIS Packages Faster
Why use Biml when SSIS already has a designer? This guest post by Reeves Smith shows how one XML file and a single variable can generate many near-identical SSIS packages, and when the extra effort pays off.
Find Rows With Single Quotes in SQL Server: SQL in Sixty Seconds #075
To find rows with single quotes, write the quote twice inside the search string. This post tests four search patterns on one million rows on SQL Server 2025, shows which two are the same query and which one costs more, and covers the curly quote that a straight quote search misses.
SQL SERVER – Search Records with Single Quotes – Part 2
Readers sent more ways to find records with single quotes: CHAR(39), CHARINDEX and REPLACE. Here are their suggestions, and all of them perform well.
SQL SERVER – Search Records with Single Quotes
A reader asked how to search records with single quotes in a table column. A simple LIKE query with doubled quotes finds them.