This script converts hierarchical adjacency into nested json rows which contain the recursive "downlines" of each node. The table-valued function treats each row in the original adjacency as the root node in a recursive common table expression.
2019-11-24
292 reads
This script converts hierarchical adjacency into nested json rows which contain the recursive "downlines" of each node. The table-valued function treats each row in the original adjacency as the root node in a recursive common table expression.
2019-11-12 (first published: 2019-11-08)
655 reads
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,078 reads
Most of DBA are coming from On-premise Database Servers they know very well How...
By Steve Jones
This is a non-technical post, and my opinion. If you don’t want to read...
By kleegeek
I’m thrilled to support and participate in this year’s VMworld 2020 conference, which is...
Summary: We had migrated SSISDB from SQL Server version 11.0.6260 to SQL Server version...
Hi, I'm using SQL Server 2017, I need to give developers only to view...
Comments posted to this topic are about the item Offline Filegroups
Ask SSC