2025-02-28
368 reads
2025-02-28
368 reads
2023-10-25
526 reads
2021-09-24
392 reads
2021-09-17
524 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-25 (first published: 2019-11-24)
740 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)
2,029 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,824 reads
This came up one day at my work when a developer was using it....
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...
By Steve Jones
When in doubt, overtip – from Excellent Advice for Living This is close to...
Comments posted to this topic are about the item How Much AI Code Would...
Comments posted to this topic are about the item Browsing for Instances
Comments posted to this topic are about the item Creating a Date Dimension (Calendar...
I have a SQL Server instance that is not listening for connections on port 1433. By default, all ports are locked down on my server, except for the SQL Server port. What can I do to allow users to connect to the instance without knowing the port?
See possible answers