Linked Questions
29 questions linked to/from Parse JSON in TSQL
5
votes
1
answer
11k
views
How to read JSON data from SQL Server? [duplicate]
I want to read Json data from SQL Server 2012, I know that it will support read Json data in SQL Server 2016, but I need a workaround way to read it now.
I have a column Text with this Json code:
{"...
1
vote
1
answer
1k
views
Is there any alternative for JSON_VALUE in SQL Server 2014? [duplicate]
Is there any alternative for JSON_VALUE in SQL Server 2014?
JSON_VALUE is supported SQL Server 2016 and higher. How can i achieve that?
0
votes
0
answers
92
views
JSON into SQL results - SQL Server 2012 [duplicate]
I have JSON definitions in a SQL table, from there I am trying to parse it into a SQL Server view or a table (anything would be helpful).
LookupJSON table has a single column called definition_JSON ...
6
votes
3
answers
51k
views
Query JSON inside SQL Server 2012 column
I have a column inside my SQL Server 2012 table which contains following Json data.
[{"bvin":"145a7170ec1247cfa077257e236fad69","id":"b06f6aa5ecd84be3aab27559daffc3a4"}]
Now I want to use this ...
4
votes
3
answers
30k
views
Parse JSON string in sql
I have a column of JSON strings in my table, I'm using SQL Server 2008.
Any Ideas on how to parse the JSON string and extract a specific value?
Here's my JSON String:
{"id":1234,"name":"Lasagne al ...
6
votes
2
answers
28k
views
Transform JSON data to separate columns
I have following DB structure:
ID Name Value
1 TV1 {"URL": "www.url.com", "Icon": "some_icon"}
2 TV2 {"URL": "www.url.com", "Icon": "some_icon", "Facebook": "Facebook_URL"}
3 TV3 {"URL":...
12
votes
2
answers
27k
views
Can you use SQL to SELECT values from a JSON array?
I have a database in SQL Server 2008 and one particular table has information stored in fields as JSON-encoded arrays. I'm wondering there's a SQL-based approach to select out specific values within ...
4
votes
2
answers
6k
views
JSON data handling in SQL Server
I have a Json string. I Want to get value from that Json string.
This is my json string
{"latitude":"22.5712854"},{"longitude":"88.4266847"}
I want only latitude and longitude from this, using TSQL ...
2
votes
4
answers
27k
views
How to parse json data in SQL Server 2012?
I am using SQL Server 2012.I have been assigned a task where one of my column (JsonText) of table Sample contains json data. I want to pass parse that data and insert into columns of another table (...
3
votes
3
answers
3k
views
Creating SQL Server JSON Parsing/Query UDF
First of all before I get into the question, I'll preface this with the fact that I know that this is a "bad" idea. But for business reasons it is something that I have to come up with a solution to, ...
1
vote
1
answer
6k
views
Split JSON data in SQL Server column
I have a table in SQL Server which has an address column of string datatype.
Address values like
{"line1":"Nav Place Road","line2":"Nyork City","line3":"USA 34576"}
I want to get result in a ...
3
votes
0
answers
9k
views
How to use OPENJSON or a compatible equivalent in SQL Server 2014?
I am aware OPENJSON is a new feature in SQL Server 2016.
I currently have the stored procedure shown below working for SQL Server 2017, but I cannot figure out a way to make it work on SQL Server ...
4
votes
2
answers
4k
views
How to parse JSON column using TSQL
I'm trying to parse a specific, valid JSON string from a column to its individual values using T-SQL.
I have looked at many of the samples, particularly this one Parse JSON in TSQL and still am not ...
0
votes
1
answer
3k
views
How to parse JSON array string by using mssql?
I've had created the function ParseJson below :
create function ParseJson(
@json nvarchar(max))
returns @tempTable table (topKey nvarchar(max), [Key] nvarchar(max), [Value] nvarchar(max))
as
...
0
votes
2
answers
2k
views
TSQL JSon Parse
I have a Json string like below I am trying to insert it as row values into the database.
so example here there would be two rows inserted into the database with 4 columns
The columns being status, ...