Inline table-valued function functions

Create an inline table-valued Function:

1  UseTSQLFundamentals2008;2 IF object_id('dbo.fn_getcustorders') is  not NULL3   DROP FUNCTIONdbo.fn_getcustorders;4 GO5 CREATE FUNCTIONdbo.fn_getcustorders6(@cid  as INT)RETURNS TABLE7  as8 RETURN9   SELECTOrderID, CustID, Empid, OrderDate, RequiredDate,Ten ShippedDate, ShipperID, freight, ShipName, shipaddress, ShipCity , One shipregion, Shippostalcode, ShipCountry A    fromsales.orders -   WHERECustID= @cid; - GO

To query this function:

1 SELECT OrderID, CustID 2  from Dbo.fn_getcustorders (1 as CO;

Inline table-valued function functions