Question

sql server 自定义函数

CREATE FUNCTION func ()
RETURNS TABLE
AS
declare @a int
if @a>=1 and @a<=dbo.getCurrentMonthDays()
RETURN (SELECT sum(totalamout) FROM tblDeliveryOrder WHERE dteTimes = dbo.getOneDay(@a))

大侠们帮我看看这哪里有错 刚自学的 不知道错哪了

Answer 1

create function func(@a int)
returns int
as
begin
if @a>=1 and @a<=dbo.getCurrentMonthDays()
set @a=(SELECT sum(totalamout) FROM tblDeliveryOrder WHERE dteTimes = dbo.getOneDay(@a))
return @a
end

因为你只返回一个值，所以没必要用表值型函数

Answer 2

再回答一次
@a没赋值