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)


19,200 reads


The End of PASS


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

Platforms for Events


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


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

Read the latest Blogs


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


SQL Server Q&A from the SQLServerCentral community

Get answers