by Hi,
I have just come across a problem that I can't feed getdate
() to functions that return a table while feeding constant
values like '1/1/01' is allowed. Anybody has comments?
Functions returning a scalar value seem to be fine.
-------------------------
returns table
as
return(
/* select statement here*/
)
---------------------
calling the function
select * from dbo.dum(getdate())
error message:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '('.
whereas feeding constant is fine
select * from dbo.dum(getdate())