如何在没有输入参数的情况下创建sql函数
create function function_name RETURN datetime AS BEGIN DECLARE @var datetime SELECT @var=CURRENT_TIMESTAMP RETURN @var END
> > Msg 156,Level 15,State 1,Procedure > fx_getcurrent_date,Line 2 Incorrect > Syntax near the keyword 'RETURN'. Msg > 178,Line 7 A RETURN > statement with a return value cannot > be used in this context.
解决方法
你错过了你的().此外,它应该是第一次RETURN的RETURNS.
CREATE FUNCTION function_name
(
)
RETURNS DATETIME
AS
BEGIN
DECLARE @var datetime
SELECT @var=CURRENT_TIMESTAMP
RETURN @var
END
