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