CREATE FUNCTION dbo.fnDateAdd()
RETURNS int
AS 
BEGIN
 RETURN 0
END
GO

CREATE FUNCTION dbo.fnDateAdd(@intA int)
RETURNS int
AS 
BEGIN
 RETURN @intA
END
GO

Christian Buettner (2/13/2008)

---

Hm, I am having a blackout:
Why is this function not deterministic?!?

CREATE FUNCTION dbo.fnDateAdd()
RETURNS int
AS 
BEGIN
 RETURN 0
END
GO

Do I need to have any special session settings enabled?
SELECT objectpropertyex(object_id('dbo.fnDateAdd'), N'IsDeterministic')
returns 0.

I am stuck...

Btw: I prefer "wrong" questions with discussions that start your brain on a topic over questions where I just get my points.

create function dbo.fndateadd2()
returns int
as begin
return dbo.fndateadd()
end
go

ALTER FUNCTION dbo.fnDateAdd(@intA int)
RETURNS int
WITH SCHEMABINDING
AS 
BEGIN
 RETURN @intA
END
GO

-- This should return 1
SELECT objectpropertyex(object_id('dbo.fnDateAdd'), N'IsDeterministic') 

-- This will only call the function once
SELECT * FROM sysobjects WHERE [id] <= dbo.fnDateAdd(object_id('dbo.fnDateAdd'))

-- This will call the function for every row in sysobjects.
SELECT * FROM sysobjects WHERE [id] <= dbo.fnDateAdd([id])

DROP FUNCTION dbo.fnDateAdd
GO
CREATE FUNCTION dbo.fnDateAdd(@intA int)
RETURNS datetime
WITH SCHEMABINDING AS 
BEGIN
 RETURN GETDATE()
END
GO

DROP FUNCTION dbo.Test
GO
CREATE FUNCTION dbo.Test()
RETURNS datetime
AS
BEGIN
	RETURN dbo.fnDateAdd(1)
END
GO
SELECT dbo.Test()