description User-defined functions accept parameters, perform an action, such as a complex calculation, and return the result of that action as a value. A user-defined function is a [!INCLUDE tsql] ...

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer need ...

sql-server-samples / samples / features / intelligent-query-processing / notebooks / Table_Variable_Deferred_Compilation.ipynb pmasl Added new notebooks to IQP demos 51a6e8a · 7 years ago ...

SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...