1.Functions

 

1.1         Functions 1.1.1        Table Valued Functions USE [WideWorldImporters] GO FUNCTION [Application].[DetermineCustomerAccess](@CityID int) RETURNS TABLE WITH SCHEMABINDING -          We can use the above function by using CROSS APPLY USE WideWorldImporters GO SELECT c.CustomerName, a.AccessResult FROM Sales.Customers c CROSS APPLY [Application].[DetermineCustomerAccess] (DeliveryCityID) a GO 1.1.2        Scalar-Valued Functions -          returns single value 1.1.3        Aggregate Functions 1.1.4        System Functions