by Hi all
I am having a problem in UDF returning the table Datatype.
With normal scalar return type the function works. WWhat
is the problem in the following function?
I call the function as
SELECT * from dbo.GetAge1(GETDATE(), GETDATE())
Result shows:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '('.
The Function created is as follows:
datetime)
(
age datetime
)
AS
BEGIN
BEGIN
END
BEGIN
BEGIN
END
END
RETURN
END
Thanks in advance,
Anand