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.
2020-10-07 (first published: 2020-09-08)
43,190 reads
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
By Steve Jones
Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by...
By Rohit Garg
How U.S.-India Tariff Disputes Could Ripple Through the Indian IT Sector Although the newly...
By Rohit Garg
Why Microsoft Azure Certifications Are Beneficial for Your Career 
How to Schedule...
I have an Open query that runs on an Always On server via a...
Comments posted to this topic are about the item What is a Failed Deployment?
Comments posted to this topic are about the item Generating a Series I
What is returned by this code in SQL Server 2022?
SELECT value FROM GENERATE_SERIES(4, 1);See possible answers