Setting variable to user defined type
I'm trying to run the following, but keep getting error message
'Incorrect Syntax near keyword DECLARE'
CREATE Function dbo.fnGetEndDate()
Returns EndDate /*This is a UDT*/
AS
DECLARE @GetEndDate as EndDate
BEGIN
Set @GetEndDate=CAST(frmLauncher.Evaluation_ID AS varchar(20))
RETURN @GetEndDate
END
|