Inline Function

SQLServerCentral Article

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.64 (14)

You rated this post out of 5. Change rating

2020-10-07 (first published: )

43,271 reads

External Article

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

Speaking at the 2025 PASS Data Community Summit

By

I will be back in Seattle this year attending the 2025 PASS Data Community...

The Book of Redgate: Motivation

By

Another of our values is this: Motivation isn’t about carrots and sticks. Constant oversight...

A Six Week Break

By

Today is my last day of work for six weeks. I start my sabbatical...

Read the latest Blogs

Forums

Three Times a Day

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Three Times a Day

SUM([value]) and highest record type

By Pete Bishop

Given a record mapping table: Id Initial Updated 1 1 2 2 3 4...

should i expect data types in task->export data from ssms?

By stan

Hi i recently exported a number of "to be purged resultsets " to .tsv's. ...

Visit the forum

Question of the Day

Multiple Defaults

In my SQL Server 2022 database, I run this code:

ALTER TABLE dbo.OrderHeader 
ADD ModifiedStamp DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE()
GO
I decide I need to add auditing to another table and run this:
ALTER TABLE dbo.Tracker
ADD Created DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE()
GO
What happens with these statements?

See possible answers