Why I can't do:
DECLARE
@dTimeStamp datetime
SELECT @dTimeStamp = getdate()
Inside of a function? ... I get an error:
Msg 443, Level 16, State 1, Procedure fcnName, Line 9
Invalid use of 'getdate' within a function.
Answer:
For some reasons Getdate() is not allowed in functions, and a few other places. This was a limitation in 2000, not anymore in 2005. Getdate() is nondeterministic function which are not allowed in 2000
Solution:
The work-around for that I use, if necessary, is to create a view based off of getdate() and call that view inside the function.
CREATE VIEW uvw_Now
AS
SELECT getdate() AS now
GO
CREATE FUNCTION udf_Now()
RETURNS datetime
AS
BEGIN
DECLARE @Now DATETIME
SELECT @Now = now FROM uvw_Now
RETURN @Now
END
GO
SELECT udf_Now()
