Inline Function

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

16,192 reads

What are Inline Indexes?

  • Article

New releases of SQL Server arrive at a quick pace, and it's difficult to keep up with the many features introduced in each version. In this article, Phil Factor reviews a feature you may have missed, inline indexes. He covers the syntax and the many ways they can be used and then performs some performance tests to see if they can make a difference with table variables.

2019-03-18

3,669 reads

Blogs

Daily Coping 25 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

VMworld 2020 – Top 10 Database Sessions (Part 1)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 24 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Always On - tips for running large transactions

By NicHopper

Hi all, I wanted to get a second opinion on something, this weekend I...

Encrypted column copy

By IT researcher

I am using SQL Server 2008 R2. I have encrypted some of the columns...

SQL query error help

By rocky_498

Hi Guys, I have a table, around 320 fields. I am trying to use...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers