Web Listing 2: Using the Table-Valued Function

-- Retrieve all product details with descriptions in Danish language if available:
SELECT * FROM GetLocalizedProductDetails('dn');

-- Retrieve product details for ProductID = 796 with description in Spanish language if available:
SELECT * FROM GetLocalizedProductDetails('es') WHERE ProductID = 796; 

-- Retrieve product details with ProductModleID = 7 in Arabic language:
SELECT * FROM GetLocalizedProductDetails('ar') WHERE ProductModelID = 7;  

-- Retrieve all product details in French language that have at least 100 items available in inventory:
SELECT * FROM GetLocalizedProductDetails('fr') AS p
 WHERE EXISTS(SELECT * FROM Production.ProductInventory AS i
               WHERE i.ProductID = p.ProductID AND i.Quantity >= 100);	

DROP FUNCTION GetLocalizedProductDetails
GO