Quaint Query for Quick Bit Flip

Written by Jamie M.
Posted on Oct 3, 2012 at 10:57 AM

How's this for the a super simple way to flip a bit field from 1 to 0 and back:

UPDATE myTable





SET myBitField = coalesce(myBitField,0) ^ 1





WHERE myPrimaryKey = 'uniqueIDHere'

I'm in love.

Share and Subscribe:

Tags:

Name: Sanj Rajput
Posts: 145
Last Post: October 10, 2024
Show Sanj's Posts

Name: Rob Matlow
Posts: 140
Last Post: June 6, 2024
Show Rob's Posts

Name: Jackie Graves
Posts: 1
Last Post: June 6, 2024
Show Jackie's Posts

Name: Melissa Yates
Posts: 1
Last Post: February 27, 2024
Show Melissa's Posts

Name: Amanda Turner
Posts: 1
Last Post: February 20, 2024
Show Amanda's Posts

Name: Alina Litvinenko
Posts: 1
Last Post: February 6, 2024
Show Alina's Posts

Name: Tabitha Doyle
Posts: 1
Last Post: January 30, 2024
Show Tabitha's Posts

Name: Christine Votruba
Posts: 31
Last Post: August 29, 2023
Show Christine's Posts

Name: Sean Sanderson
Posts: 66
Last Post: December 19, 2022
Show Sean's Posts

Name: Haley Burton
Posts: 1
Last Post: December 7, 2021
Show Haley's Posts

Name: Generic Administrator
Posts: 1
Last Post: December 3, 2021
Show Generic's Posts

Name: Colleen Legge
Posts: 1
Last Post: November 26, 2021
Show Colleen's Posts

Name: Sean McParland
Posts: 18
Last Post: August 20, 2021
Show Sean's Posts

Name: Matt Stern
Posts: 4
Last Post: July 16, 2019
Show Matt's Posts

Name: Sean Legge
Posts: 1
Last Post: June 28, 2019
Show Sean's Posts

Name: Todd Hannigan
Posts: 47
Last Post: November 13, 2018
Show Todd's Posts