SQL Server converting "IN" to "OR" condition internally

• Chinna

  SSCertifiable

  Points: 5408

  More actions

  October 10, 2023 at 10:29 pm

  #4305419

  I have a TFS script with Check constraint " Check Col1 in (1,2)"  when deployed to database its changing the script to "Check Col1 =1 or Col1 =2 " which is correct as well but everytime i want to generate delta for any deployments its coming up all the time. Any setting which can help identify that both are same or anyway of deploying it so that it remains as "IN".

  Thanks in Advance.

  • This topic was modified 1 year, 2 months ago by  Chinna.
  • This topic was modified 1 year, 2 months ago by  Chinna.

  Thanks,
  Chinna

  Its the Journey which gives you Happiness not the Destination-- Dan Millman

• CreateIndexNonclustered

  SSChasing Mays

  Points: 648

  More actions

  October 10, 2023 at 11:01 pm

  #4305430

  That is how the IN operator functions, it interprets to a series of OR operators.

• Phil Parkin

  SSC Guru

  Points: 246988

  More actions

  October 11, 2023 at 2:08 pm

  #4305917

  What tools are you using to deploy and to generate the delta?

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• October 30, 2023 at 7:53 am

  This was removed by the editor as SPAM