Mega Code Archive

 

Categories / MSSQL Tutorial / Data Types

 

Return money type from function

5>     CREATE FUNCTION dbo.AveragePrice() 6>    RETURNS money 7>    WITH SCHEMABINDING 8>    AS 9>    BEGIN 10>       RETURN (SELECT AVG(Price) FROM dbo.Titles) 11>    END 12> GO 1> 2>    SELECT OBJECTPROPERTY(OBJECT_ID('AveragePrice'), 'IsDeterministic') 3> GO -----------           1 (1 rows affected) 1> 2> drop FUNCTION dbo.AveragePrice; 3> GO