locked
for json path giving error in server RRS feed

  • Question

  • User-257070954 posted

    Hi All,

           One of the my query working fine in my local. But  giving error in server Below giving sample query

          select 'b' as name for json path   this query  giving expected result in local

           [{"name":"b"}]

       But this same query giving error in  server. Below is error

       Msg 102, Level 15, State 1, Line number 1
         Incorrect syntax near 'json'.

        Please let me know whats the reason giving error in  server

    Thursday, July 23, 2020 2:13 PM

All replies