Table Valued Function (TVF)

Creating and Using Inline Table-Valued Functions

  • Article

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.

4.55 (11)

2020-09-08

17,918 reads

Blogs

Power BI – Hungry Median – Aggregations

By

Introduction In my last blog post, I have addressed an issue with DAX Median...

Inspector 2.4 now available

By

All the changes for this release can be found in the Github Project page...

Basic JSON Queries–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

SSIS Startup directory not found

By wburke 85918

This seems to be a common issue throughout my packages. Anywhere I try to...

What is the best way to create events from table inserts in SQL Server

By Joseph Termine

I have a SQL 20XX database in an on-premise data center that has a...

HA in General Purpose Managed Instance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item HA in General Purpose Managed...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers