{"id":2312,"date":"2021-12-06T07:02:47","date_gmt":"2021-12-06T07:02:47","guid":{"rendered":"https:\/\/erpconsultors.com\/?p=2312"},"modified":"2021-12-06T07:05:08","modified_gmt":"2021-12-06T07:05:08","slug":"convert-sql-query-into-json-format-in-sql-server","status":"publish","type":"post","link":"https:\/\/erpconsultors.com\/convert-sql-query-into-json-format-in-sql-server\/","title":{"rendered":"How to convert SQL Query into JSON Format in SQL Server"},"content":{"rendered":"\n

Convert SQl Query into JSON Format in SQL Server:<\/h2>\n\n\n\n

(1) \u201cSELECT\u201d statement used for select records in table form database.<\/p>\n\n\n\n

(2) Syntax of \u201cSELECT\u201d statement is:<\/p>\n\n\n\n

SELECT column1, column2, \u2026
FROM table_name for JSON AUTO;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

(3) Let’s take an example to select records for \u201cVendor table\u201d and show them in \u201cJSON\u201d format.<\/p>\n\n\n\n

(4) Select the database in the SQL server and click on the \u201cNew Query\u201d button as shown:<\/p>\n\n\n\n

\"select<\/figure><\/div>\n\n\n\n

(5) After that new query editor open as shown:<\/p>\n\n\n\n

\"new<\/figure><\/div>\n\n\n\n

(6) After doing the above steps, write query in the editor, as shown:<\/p>\n\n\n\n

\"write<\/figure><\/div>\n\n\n\n

Source Code:<\/strong><\/p>\n\n\n\n

–\/\/SQL data convert in JSON fomat. All fields show in json format
Select * from dbo.[CRONUS India Ltd_$Vendor$d3c551dd-5903-4194-b153-04ced9d29a2c] for JSON AUTO
–\/\/SQL data convert in JSON fomat. All fields show in json format

–\/\/SQL data convert in JSON fomat. Particulats fields show in json format
Select [No_], [P_A_N_ No_], [State Code] from dbo. [CRONUS India Ltd_$Vendor$d3c551dd-5903-4194-b153-04ced9d29a2c] for JSON AUTO
–\/\/SQL data convert in JSON fomat. All fields show in json format<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

(7) After writing the query, then execute the query (Shortcut keys is F5) as as shown.<\/p>\n\n\n\n

\"execute<\/figure><\/div>\n\n\n\n
\n\n\n\n
AL Control Statements in Business Central<\/span><\/a>
Use of SETRANGE and SETFILTER in Dynamics 365<\/span><\/a>
How to use FOR-TO loop statement in Microsoft D365<\/span><\/a>
Create Export to Excel Report in Business Central<\/span><\/a>
Issue in Installing AL Symbol in VS editor [Solved]<\/span><\/a>
OnAfterValidateEvent (Table) Trigger Event<\/span><\/a>\u2013 Microsoft Docs<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

Convert SQl Query into JSON Format in SQL Server: (1) \u201cSELECT\u201d statement used for select records in table form database. (2) Syntax of \u201cSELECT\u201d statement is: SELECT column1, column2, \u2026FROM table_name for JSON AUTO; (3) Let’s take an example to select records for \u201cVendor table\u201d and show them in \u201cJSON\u201d format. (4) Select the database in the SQL server and click on the \u201cNew Query\u201d button as shown: (5) After that new query editor open as shown: (6) After doing the above steps, write query in the editor, as shown: Source Code: –\/\/SQL data convert in JSON fomat. All fields show in json <\/p>\n","protected":false},"author":1,"featured_media":2347,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[48],"tags":[253,252],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/Convert-SQl-Query-into-JSON-Format-in-SQL-Server.jpg?fit=350%2C270&ssl=1","_links":{"self":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/2312"}],"collection":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/comments?post=2312"}],"version-history":[{"count":0,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/2312\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media\/2347"}],"wp:attachment":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media?parent=2312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/categories?post=2312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/tags?post=2312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}