Hi everybody,
I always thought that
1) non-deterministic functions weren't allowed in user-defined functions
2) Getdate() is non-deterministic
3) Therefore I shouldn't be able to use it in a function,
but this compiles just fine:
create function dbo.bbb ()
returns datetime
as
begin
return getdate();
end;
What am I not seeing here? 😛
Thanks!