Uncategorized

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

20,478 reads

Blogs

Goal Progress–Feb 2021

By

I set goals at the beginning of the year, and I’m tracking my progress...

How to: exec sp_help on temp tables?

By

Say you have a temp table and you want to see the columns names. For...

Daily Coping 26 Feb 2021

By

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

Read the latest Blogs

Forums

Question about deadlock

By sqlenthu 89358

Hello DBAs, I am facing some deadlock issue and after investigation from trace flag...

Get Date Based on TimeOffSet and Day

By Rock

Team I have a table which carries the below columns and values TimeOffSet >...

MSDTC and Always On AG

By VastSQL

Hi Experts, We are planning to implement 2 Node AO SQL Server 2019. For...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers