Understanding OPENJSON and FOR JSON in Azure and SQL 2016
An example of exporting and importing table data with JSON in Azure and SQL Server 2016.
2017-06-09 (first published: 2016-05-05)
3,092 reads
Ryan Loftin
Consuming JSON Formatted API Data in 2016
Natively consume JSON data from API sources with SQL 2016 and CLR
2016-06-02
5,170 reads
Blogs
Daily Coping 18 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Optimize for Unknown for Inline Table-Valued Functions
I had a curious performance issue today. An inline table-valued function (iTVF) was performing...
Daily Coping 17 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
How to create a minimal tally table and to describe its advantages (if any)
What is the minimal way to create a tally table/tvf/cte and to describe its...
Need some help with log file
I have an issue with a log file which I am trying to solve....
Querying a table to get the columns with values
Morning, i have a table with over 100 columns and i need to query...
Ask SSC