Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag JSON Rss

   Items 1 to 8 of 8   


By Steve Jones 2015/09/07 | Category: json
Rating: (not yet rated) |  Discuss |   Briefcase | 1,504 reads

NoSQL inside SQL Server

This week Steve Jones looks at the idea of combining some NoSQL concepts inside of SQL Server.  Read more...
By Steve Jones 2015/09/07 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 167 reads

JSON Select - Easily query values from JSON

Introducing JSON Select - a new library that makes it easy to pull values out of JSON strings in SQL Server 2005+  Read more...
By Joshua Healy 2015/08/31 | Source: | Category: json
Rating: |  Discuss |   Briefcase | 9,656 reads


By pramod singla 2015/06/19 | Category: sql server 2016
Rating: (not yet rated) |  Discuss |   Briefcase | 1,355 reads

Producing JSON Documents from SQL Server queries via TSQL

Although SQL Server supports XML well, XML's little cousin JSON gets no love. This is frustrating now that JSON is in so much demand. Maybe, Phil Factor suggests, it is possible to leverage all that XML, and XPath, goodness in SQL Server to produce JSON in a versatile way from SQL Queries? Yes, it so happens that there are plenty of alternatives.  Read more...
By Additional Articles 2014/05/22 | Source: SimpleTalk
Rating:  Rate this |   Briefcase | 7,845 reads

JSON and the NoSQL “advantage” over SQL Server

First what is JSON? JSON: JavaScript Object Notation. JSON is syntax for storing and exchanging text information, similar to XML. JSON is smaller...  Read more...
By 2012/06/25 | Source: | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 13,797 reads

JSON.SQL: A CLR-resident JSON serializer/deserializer for SQL Server

One CLR function and four CLR procedures for the import/export of JSON data to and from SQL Server are presented, with supporting performance metrics.  Read more...
By Bret Lowery 2011/07/18 | Source: | Category: sqlclr
Rating: |  Discuss |   Briefcase | 9,208 reads

A Function to Split JSON Data

JSON is Javascript Object Notation and it's a format for exchanging data. New author Ric Vander Ark brings us an article that shows how to implement a function to split out the data into a table format and gives a number of examples for different data.  Read more...
By Ric Vander Ark 2009/09/23 | Source: | Category: json
Rating: |  Discuss |   Briefcase | 11,550 reads
   Items 1 to 8 of 8   
bcp (1)    
blogs (1)    
bulkcopy (1)    
c# (1)    
database weekly (1)    
editorial (1)    
export (1)    
import (1)    
javascript (1)    
nosql (1)    
split (1)    
sql server 2016 (1)    
sqlclr (1)    
t-sql (1)