Kimani Mbugua

  • Interests: Cricket, karting, deading and dad jokes.

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-09-08

19,200 reads

Blogs

The End of PASS

By

I think our profession was the better for having a professional association, even if...

Platforms for Events

By

in my last post I wrote about thinking of the tools as being a...

Getting Started with Robotic Process Automation (RPA) Using the Power Automate Desktop

By

There are a lot of hot phrases you’ve likely heard thrown around during various...

Read the latest Blogs

Forums

Migrating from 2008/2012 SQLserver to new server with sqlserver2019

By caz100

Anyone have a guide on how I migrate SSIS from sqlserver 2008 / 2012...

sp_execute and sp_executesql and sp_prepexec for the same statement

By scott.laird

From our software provided by a third party vendor, I am seeing the following:...

"Home PC" SQL instance

By ifthir

This may be a bit non-typical, but I am currently running SQL 2019 Developer...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers