In this article, I am going to discuss the User-Defined Inline Table-Valued Function in SQL Server with Examples. Please read our previous article where we discussed User-Defined Scalar Valued ...

Using a variable within an IN clause in SQL Server can be done in several ways depending on the context and what kind of data you are working with. Below are different methods to achieve this. Let's ...

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 ...

PL/SQL loop or in SQL as a table function. Created by Carsten Czarski -- Create type to describe a table row -- This type describes a row of the String Tokenizers' result table.

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 ...