LISTING 1: Script That Creates Two UDFs

CREATE FUNCTION GetBigOrdersMultiStatement()
RETURNS @Orders TABLE
(
	[NewId] INT primary key,
	[OrderID] [int] NOT NULL ,
	[CustomerID] [nchar] (5)  NULL ,
	[EmployeeID] [int] NULL ,
	[OrderDate] [datetime] NULL ,
	[RequiredDate] [datetime] NULL ,
	[ShippedDate] [datetime] NULL ,
	[ShipVia] [int] NULL ,
	[Freight] [money] NULL ,
	[ShipName] [nvarchar] (40) NULL ,
	[ShipAddress] [nvarchar] (60)  NULL ,
	[ShipCity] [nvarchar] (15)  NULL ,
	[ShipRegion] [nvarchar] (15) NULL ,
	[ShipPostalCode] [nvarchar] (10) NULL ,
	[ShipCountry] [nvarchar] (15) NULL
)
AS
BEGIN

INSERT INTO @Orders SELECT * FROM BigOrders
RETURN
END
GO

CREATE FUNCTION GetBigOrdersInLine()
RETURNS TABLE
AS
RETURN
(
SELECT * FROM BigOrders
)
GO