{"id":27401,"date":"2023-08-01T07:11:00","date_gmt":"2023-08-01T05:11:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=27401"},"modified":"2023-10-10T18:46:43","modified_gmt":"2023-10-10T16:46:43","slug":"how-to-use-sql-server-json-functions","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/","title":{"rendered":"How to use SQL Server JSON functions?"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\" id=\"h-introduction-to-the-sql-server-json-value-query-and-modify-functions\"><strong><em>Introduction to the SQL Server JSON value, query and modify functions.<\/em><\/strong><\/h4>\n\n\n\n<p>In the world of data management and IT, including of course SQL Server, the use of JSON (JavaScript Object Notation) has become increasingly popular due to its lightweight data-interchange format. As a result, SQL Server has incorporated a set of <strong>SQL Server JSON functions<\/strong> in T-SQL to handle JSON data. This tutorial will guide you on how to use these functions, starting from the basics and gradually moving to more complex examples.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#1-understanding-json-data-format-in-sql-server\" >1. Understanding JSON Data format in SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#2-the-json-value-function-in-sql-server\" >2. The JSON_VALUE function in SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#3-working-with-json-query-in-ms-sql\" >3. Working with JSON_QUERY in MS SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#4-exploring-the-isjson-function-in-t-sql\" >4. Exploring the ISJSON Function in T-SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#5-using-the-json-modify-function-in-sql-server\" >5. Using the JSON_MODIFY Function in SQL Server<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-understanding-json-data-format-in-sql-server\"><span class=\"ez-toc-section\" id=\"1-understanding-json-data-format-in-sql-server\"><\/span>1. Understanding JSON Data format in SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Before diving into the <strong>MS SQL JSON functions<\/strong>, it&#8217;s crucial to understand what JSON data is. JSON data is a text format that is completely language independent but uses conventions that are familiar to programmers of the C family of languages. In SQL, JSON <a href=\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-data-types\/\"><strong>is stored as NVARCHAR type<\/strong><\/a>. Here&#8217;s how to create a table with JSON data:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Use [Expert-Only];\n \nCREATE TABLE Employees (\n    ID INT IDENTITY(1,1),\n    Info NVARCHAR(4000)\n);\n\nINSERT INTO Employees (Info)\nVALUES\n   ('{\"Name\": \"John\", \"Age\": 25, \"Department\": \"Sales\"}'),\n   ('{\"Name\": \"Jane\", \"Age\": 30, \"Department\": \"Marketing\"}');\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-the-json-value-function-in-sql-server\"><span class=\"ez-toc-section\" id=\"2-the-json-value-function-in-sql-server\"><\/span>2. The JSON_VALUE function in SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>About Transact-SQL JSON functions, one of the primary functions that stands out is JSON_VALUE. Designed with a simple purpose, <strong>the JSON_VALUE function serves the specific role of extracting scalar values from a comprehensive JSON string<\/strong>. Scalar values, in this context, refer to single, non-repeated data points within the JSON structure, such as integers, booleans, or strings<\/p>\n\n\n\n<p>The first function to explore in the <strong>Transact-SQL JSON functions<\/strong> is JSON_VALUE. This function extracts a scalar value from a JSON string. Here&#8217;s a simple example with a query that will simply return the names of the employees from the JSON data.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"> SELECT JSON_VALUE(Info, '$.Name') AS EmployeeName\n FROM Employees\n <\/pre>\n\n\n\n<p>The following screenshot group in one image the execution of the two previous T-SQL statement, including these 4 operations: <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select the target database<\/li>\n\n\n\n<li>Create the Employee table with a JSON column<\/li>\n\n\n\n<li>Insert 2 lines using the JSON data format<\/li>\n\n\n\n<li>Select the name value using the JSON_VALUE built-in function<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"560\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/10\/sql-server-table-with-json-data.jpg\" alt=\"Create a table with a column in JSON format and select value using JSON_VALUE function\" class=\"wp-image-27540\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/10\/sql-server-table-with-json-data.jpg 900w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/10\/sql-server-table-with-json-data-300x187.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/10\/sql-server-table-with-json-data-768x478.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption class=\"wp-element-caption\"><em>Create a table with a column in JSON format and select value using JSON_VALUE function<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-working-with-json-query-in-ms-sql\"><span class=\"ez-toc-section\" id=\"3-working-with-json-query-in-ms-sql\"><\/span>3. Working with JSON_QUERY in MS SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>JSON_QUERY is another function in the suite of <strong>SQL Server JSON functions<\/strong>. Unlike JSON_VALUE, JSON_QUERY extracts an object or an array from a JSON string. Here&#8217;s below a basic example on how to use it. This query will return the entire JSON data for each employee.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"> SELECT JSON_QUERY(Info, '$') AS EmployeeInfo\n FROM Employees\n <\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-4-exploring-the-isjson-function-in-t-sql\"><span class=\"ez-toc-section\" id=\"4-exploring-the-isjson-function-in-t-sql\"><\/span>4. Exploring the ISJSON Function in T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In the suite of T-SQL&#8217;s JSON functions, ISJSON stands as a practical tool. Its primary role is to ascertain the validity of a string as proper JSON format. When presented with a string, <strong>ISJSON will return a value of 1 if the string adheres to the JSON standard, and a 0 if it doesn&#8217;t<\/strong>.<\/p>\n\n\n\n<p>To better understand its application, consider the following scenario: A database contains a table named <strong><em>Employees<\/em><\/strong>, and within this table, there&#8217;s a column named <strong><em>Info<\/em><\/strong>. Each entry in the Info column is expected to be in <a href=\"https:\/\/fr.wikipedia.org\/wiki\/JavaScript_Object_Notation\" target=\"_blank\" rel=\"noreferrer noopener\">JSON format<\/a>. If there&#8217;s a need to validate this data, the ISJSON function can be employed.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"> SELECT ISJSON(Info) AS IsJson\n FROM Employees\n <\/pre>\n\n\n\n<p>A result of 1 would indicate that the corresponding &#8216;Info&#8217; field contains a valid JSON string. If the database is well-maintained and consistent, we can anticipate seeing a 1 for each record, signifying that all &#8216;Info&#8217; entries are valid JSON.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-5-using-the-json-modify-function-in-sql-server\"><span class=\"ez-toc-section\" id=\"5-using-the-json-modify-function-in-sql-server\"><\/span>5. Using the JSON_MODIFY Function in SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The JSON_MODIFY function in <strong>SQL Server JSON functions<\/strong> allows modifying a value in a JSON string. This query will update John&#8217;s age to 26 in the JSON data.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"> UPDATE Employees\n SET Info = JSON_MODIFY(Info, '$.Age', 26)\n WHERE JSON_VALUE(Info, '$.Name') = 'John'\n <\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-conclusion-about-sql-server-json-functions\">Conclusion about SQL Server JSON Functions<\/h3>\n\n\n\n<p>In conclusion, SQL Server provides a robust set of <strong>JSON functions<\/strong> to work with JSON data. These functions provide a seamless way to integrate JSON data handling into your SQL operations. Whether you&#8217;re extracting values, modifying data, or validating JSON strings, these functions make it easier and more efficient. By mastering these <strong>SQL Server JSON functions<\/strong>, you&#8217;ll be able to handle JSON data with ease and efficiency in your SQL Server database. Of course SQL Server, like <strong><a href=\"https:\/\/expert-only.com\/en\/python\/python-import-csv-data-to-sql-server\/\">Python<\/a><\/strong>, also allows users to <a href=\"https:\/\/expert-only.com\/en\/t-sql\/xml-query-method-sql-server\/\"><strong>manage XML data types using native T-SQL functions<\/strong><\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"4k8GMGWCwd\"><a href=\"https:\/\/expert-only.com\/en\/t-sql\/xml-query-method-sql-server\/\">How to use the XML query() Method in SQL Server?<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;How to use the XML query() Method in SQL Server?&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/t-sql\/xml-query-method-sql-server\/embed\/#?secret=9sVYyWbYdY#?secret=4k8GMGWCwd\" data-secret=\"4k8GMGWCwd\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>For further reading, you may want to check out the official Microsoft documentation on <a href=\"https:\/\/www.w3schools.com\/js\/js_json.asp\" target=\"_blank\" rel=\"noreferrer noopener\">JSON functions<\/a>. Another great resource is this <a href=\"https:\/\/www.w3schools.com\/sql\/sql_json.asp\">W3Schools tutorial<\/a> on SQL and JSON.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Introduction to the SQL Server JSON value, query and modify functions. In the world of data management and IT, including of course SQL Server, the use of JSON (JavaScript Object Notation) has become increasingly popular due to its lightweight <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/\" title=\"How to use SQL Server JSON functions?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10734,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[454],"tags":[],"class_list":{"0":"post-27401","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to use SQL Server JSON functions? T-SQL<\/title>\n<meta name=\"description\" content=\"Use the JSON standard format using SQL Server native functions like JSON_VALUE, JSON_QUERY or ISJSON, with practical examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to use SQL Server JSON functions?\" \/>\n<meta property=\"og:description\" content=\"Use the JSON standard format using SQL Server native functions like JSON_VALUE, JSON_QUERY or ISJSON, with practical examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-01T05:11:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-10T16:46:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"How to use SQL Server JSON functions?\",\"datePublished\":\"2023-08-01T05:11:00+00:00\",\"dateModified\":\"2023-10-10T16:46:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/\"},\"wordCount\":707,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/\",\"url\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/\",\"name\":\"How to use SQL Server JSON functions? T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg\",\"datePublished\":\"2023-08-01T05:11:00+00:00\",\"dateModified\":\"2023-10-10T16:46:43+00:00\",\"description\":\"Use the JSON standard format using SQL Server native functions like JSON_VALUE, JSON_QUERY or ISJSON, with practical examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to use SQL Server JSON functions?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to use SQL Server JSON functions? T-SQL","description":"Use the JSON standard format using SQL Server native functions like JSON_VALUE, JSON_QUERY or ISJSON, with practical examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/","og_locale":"en_US","og_type":"article","og_title":"How to use SQL Server JSON functions?","og_description":"Use the JSON standard format using SQL Server native functions like JSON_VALUE, JSON_QUERY or ISJSON, with practical examples.","og_url":"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-08-01T05:11:00+00:00","article_modified_time":"2023-10-10T16:46:43+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"How to use SQL Server JSON functions?","datePublished":"2023-08-01T05:11:00+00:00","dateModified":"2023-10-10T16:46:43+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/"},"wordCount":707,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/","url":"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/","name":"How to use SQL Server JSON functions? T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg","datePublished":"2023-08-01T05:11:00+00:00","dateModified":"2023-10-10T16:46:43+00:00","description":"Use the JSON standard format using SQL Server native functions like JSON_VALUE, JSON_QUERY or ISJSON, with practical examples.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-use-sql-server-json-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"How to use SQL Server JSON functions?"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/27401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=27401"}],"version-history":[{"count":25,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/27401\/revisions"}],"predecessor-version":[{"id":27546,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/27401\/revisions\/27546"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/10734"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=27401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=27401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=27401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}