Passing parameters to query without TVFs

This article looks at an interesting way to help your users get filtered data from a TVF instead of using a stored procedure or specialized view.

Creating and Using Inline Table-Valued Functions

Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000.

iTVFs remain a very useful tool in our SQL armoury, so let's quickly revisit them and the different ways we can use them in our code.

Get Modified Objects As on Date

This table Valued Function return the Modified Objects (SP /Views) For the Date specified.

Table-valued function FTParsedINT

This tabled valued function can be used to parse a comma seperated list of IDs so you can pass a parameter to use in a in clause without having to use dynamic SQL.