Format wants to capitalize the OPENJSON "key" column to "Key"

• 
  Now that I mention it, the [value] column also gets CamelCased to [Value] every time too.

  Number2 September 24, 2017 16:58

  - 0 +
• 
  Hey @Number2 ,
  
  Just to check, have you tried turning off the formatting option under Global > Casing > User-defined objects > Use object definition case? I think that the Key and Value columns are declared as camel-case.
  
  If this doesn't help then let me know!
  Thanks,
  James

  James R September 25, 2017 08:58

  - 0 +
• 
  When I turn that off, then it casts them as all uppercase instead of camel.

  Number2 September 25, 2017 14:03

  - 0 +
• 
  Which version of SQL Prompt? If I turn off the option for user defined objects, I get things formatted as:
  
  DECLARE @json NVARCHAR(4000)
  = N'{
  "key":1,
  "name" : { "firstname":"Steve", "lastname":"Jones"} ,
  "Employer":"Redgate",
  "Sites":{ "primary":"SQLServerCentral", "secondary":"tsqltuesday.com"}
  }'
  ;
  SELECT [key] FROM OPENJSON(@json) AS oj
  ;
  

  way0utwest September 25, 2017 16:54

  - 0 +
• 
  OK, I see what's happening...we've got two things causing this. One is the formatting from CTRL+K,CTRL+Y and the other is the inline-formatting/replacing feature like when you have SELECT * FROM OPENJSON() and then hit TAB when you're on that * to have it auto-expand that star into the columns. That one will also convert them to Key Value camel.
  
  So, with USER-DEFINED OBJECTS -> USE OBJECT DEFINITION CASE as UNCHECKED, the CTRL+K, CTRL+Y formatting does NOT exhibit this problem, but the TAB expansion of columns where it replaces text as you're typing, that DOES still camel case it for me.
  
  Version 8.0.11.2296

  Number2 September 26, 2017 23:02

  - 0 +

Add comment

Please sign in to leave a comment.