OPENJSON requires Compatibility Level 130
Parse and Transform JSON Data with OPENJSON
OPENJSON requires Compatibility Level 130
The OPENJSON function is available only under compatibility level 130. If your database compatibility level is lower than 130, SQL Server can't find and run the OPENJSON function. Other built-in JSON functions are available at all compatibility levels.
You can check compatibility level in the sys.databases view or in database properties.
You can change the compatibility level of a database by using the following command:ALTER DATABASE <DatabaseName> SET COMPATIBILITY_LEVEL = 130
作者:Chuck Lu GitHub |
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步
· 全程不用写代码，我用AI程序员写了一个飞机大战
· DeepSeek 开源周回顾「GitHub 热点速览」
· MongoDB 8.0这个新功能碉堡了，比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· 白话解读 Dapr 1.15：你的「微服务管家」又秀新绝活了
2021-01-23 整理几个被遗忘的js基础代码题，还都能答对吗？
2021-01-23 MDN Web Docs Glossary: Definitions of Web-related terms Hoisting
2021-01-23 What is the scope of variables in JavaScript? 还没看完
2020-01-23 迅雷的替代 uTorrent
2019-01-23 Can't bind multiple parameters ('header' and 'parameters') to the request's content.
2019-01-23 Routing and Action Selection in ASP.NET Web API