Turn varbinary bit ON/OFF

• ofer bester

  Valued Member

  Points: 57

  More actions

  May 8, 2012 at 12:06 pm

  #261058

  Comments posted to this topic are about the item Turn varbinary bit ON/OFF

• jfogel

  SSCarpal Tunnel

  Points: 4155

  More actions

  May 22, 2012 at 7:36 am

  #1491081

  Um, give the function a parameter so it can do either on or off. Two functions for this is a no no.

  Cheers

• Mike Dougherty-384281

  SSCrazy

  Points: 2794

  More actions

  May 22, 2012 at 8:05 am

  #1491100

  Use-case?

  Part of what makes SQLServerCentral articles interesting to read is the story that explains the code. What prompted you to write these functions?

  Even if this solution "works" - what problem does it solve?

  Why is this solution better than the approach *I* might have created?

  (I'd probably not think to write/employ the functions you've written)

  Summary: "more please"

• bester.ofer

  SSC Rookie

  Points: 38

  More actions

  May 22, 2012 at 9:13 am

  #1491162

  I agree - the two functions can be merged easily.

  I intentionally did not mix the two to enable a clear understanding.

• bester.ofer

  SSC Rookie

  Points: 38

  More actions

  May 22, 2012 at 9:16 am

  #1491164

  Sorry but i cant provide one.

  A friend requested that i'll send him the functions ASAP. after it was done i remembered i posted something similar a few years back so i loaded those two as well.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 10, 2016 at 1:46 pm

  #1877944

  Thanks for the script.