A window is defined using the OVER() clause in SQL. Functions are predefined in SQL and you use them to perform operations on data. They let you do things like aggregating data, formatting ...

At which point the CROSS APPLY operator can be used to simulate a normal scalar function call. And as the name implies, inline TVFs are inlined and optimized as normal. Starting with SQL Server ...