APPLY operator was introduced in Sql Server 2005. The main purpose of the APPLY operator is to JOIN a Table with a Table Valued User Defined Function. The APPLY operator invokes/executes the Table …