The Upgraded Procedure part 2

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736291

  More actions

  September 25, 2023 at 12:00 am

  #4255302

  Comments posted to this topic are about the item The Upgraded Procedure part 2

• Carlo Romagnano

  SSC-Insane

  Points: 22672

  More actions

  September 25, 2023 at 9:15 am

  #4293508

  I didn't see the dbo schema before OPENJSON.

  So the answer is correct, but not the explanation.

  The query fails not because of compaibility level, but because of dbo schema before OPENJSON.

  SELECT * FROM dbo.OPENJSON('{ "key":1 }')