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

22,588 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

2020 Advent of Code – Day 5

By

This series looks at the Advent of Code challenges. As one of my goals,...

What’s new with Power BI?

By

At the Microsoft Business Applications Summit 2021, a ton of new features for Power...

Tech Field Day 23 Recap

By

April 21 to 23 saw a new milestone for me. I was a new...

Read the latest Blogs

Forums

Availability Group with Replication

By sqlguru

I have configured availability group for automatic failover with synchronous mode. So that way...

Joining 3 tables

By Ctalley13

Hello All, I am new to the SQL world and with work I use...

Geocoding in SQL Server - do I need C# for it?

By pietlinden

I've been digging around playing with spatial maps in SQL Server.  I've read a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers