Kimani Mbugua

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.

4.55 (11)

2020-06-19 (first published: )

15,152 reads

Blogs

SQL Clone Works with FILESTREAM

By

SQL Clone is an amazing product that virtualizes your data, allowing multiple instances to...

Fun and profit with UTF-8

By

When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available...

Data Platform MVP 2020

By

I am humbled to be among so many great professionals and honored at the...

Read the latest Blogs

Forums

Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

Total of topN, total of other employees, total of all

By meddojeddo

I have a table which includes the columns Branch, Employee, Year, Sales and Revenue....

SSIS package to unix

By danssms

I created files from SSIS to a share folder in windows. I want to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers