TechRepublic

Passing table valued parameters in SQL Server 2008

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter ...
GitHub

Table_Variable_Deferred_Compilation.ipynb

Table_Variable_Deferred_Compilation.ipynb IQP Demo - APPROX_COUNT_DISTINCT.sql IQP Demo - Batch Mode Adaptive Join.sql IQP Demo - Batch Mode MGF.sql IQP Demo - Batch Mode on Rowstore.sql IQP Demo - ...
Visual Studio Magazine

Converting JSON Objects to Relational Tables, Part 2: Creating Related Tables

SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign ...