About SQL Server Table-valued Functions

If you want to generate the compiled form each time a SQL Server procedure is executed, use the WITH RECOMPILE option. Learn more.

Read More