LISTING 3: Two UDFs That Demonstrate Performance

USE northwind
GO

CREATE FUNCTION DoAlmostNothing()
RETURNS int
AS
BEGIN

DECLARE @ReturnVal int

SET @ReturnVal = 10

RETURN @ReturnVal

END

GO

CREATE FUNCTION PerformHeavyIO()
RETURNS int
AS
BEGIN

DECLARE @ReturnVal int

SELECT 
	@ReturnVal = count(description)
FROM
	master..sysmessages


RETURN @ReturnVal

END

GO