JSON in SQL Server

preview_player
Показать описание
Data is received in many different formats including text files, comma separated value files, excel spreadsheets, XML files and JSON files. It is crucial for anyone in the data analytics arena to be able to receive and output data in these various formats.

This video introduces the JSON format as it relates to SQL Server and shows an example of parsing the JSON into columns in the database. SQL Server has extensive facilities to consume and produce JSON.
  1. SQL Data Ninja
Рекомендации по теме
How to Work 0:28:06

How to Work with JSON Data in SQL Server (Simple and Complex JSON)

How to load 0:08:08

How to load JSON file to SQL Server?

JSON and SQL 0:13:36

JSON and SQL Tutorial - Convert a table to JSON and JSON to table

How to convert 0:24:08

How to convert JSON to SQL and SQL results to JSON? | Work with JSON Data in SQL

Parse and Query 0:08:24

Parse and Query JSON Data with SQL

Deep dive: Using 0:43:08

Deep dive: Using JSON with SQL Server

SQL+JSON 0:04:28

SQL+JSON

Parse JSON string 0:10:36

Parse JSON string with nested elements in SQL Server

codeManS LIVE! Wednesday, 0:32:01

codeManS LIVE! Wednesday, October 23, 2024 | Exercise: Geodata

Performance Testing JSON 0:15:48

Performance Testing JSON in SQL Server vs C#

How to read 0:03:15

How to read json in Sql Server

How do you 0:08:34

How do you use JSON data in Azure SQL Database & SQL Server 2022 | Data Exposed

How to convert 0:00:35

How to convert JSON to SQL in 30 seconds

Convert a JSON 0:00:18

Convert a JSON file to a SQL Database in 30 seconds

Searching Complex JSON 0:05:08

Searching Complex JSON in SQL Server

JSON in SQL 0:01:02

JSON in SQL Server

Using JSON with 0:54:19

Using JSON with SQL Server 2016

SQL Server - 0:09:37

SQL Server - Working with JSON Part 1: FOR JSON PATH

Read JSON data 0:03:59

Read JSON data from a table and parse it to rows and columns

Native JSON support 0:05:28

Native JSON support in SQL Server 2016

How to read 0:09:13

How to read JSON in SQL Server

Introduction to JSON 0:11:10

Introduction to JSON in SQL Server 2016 Part1

Advanced Data Types 1:19:56

Advanced Data Types JSON in SQL Server

Import JSON data 0:05:00

Import JSON data into SQL Server with 3 steps

Комментарии
Автор

Hi, I have a difficult task and can't decide where to ask.

I have some data in a MySQL database. I save a relay state that controls my heater each time the the temperature goes above or below a set point.
In the 'relay_state' table I have alternating rows of state 0 and 1 at different times. The table has a timestamp with default current_timestamp() on insert.
I know it will be difficult to calculate the times in between 1 and 0 states (or 0 and 1), so I know how much time the heater was ON or OFF.
I can try this in php but I have no clue how to calculate times...

Is there any way to calculate this from a SQL query? You are the Ninja and hopefully you can help me out with this one, or point me in the right direction...

btw, thank you or the knowledge you share with us.

JLaurel