SQL函数调用

函数如下

CREATE FUNCTION StockBalance_AmountIn(@SortID int)

RETURNS numeric(18,4)

AS

BEGIN

Declare @dblReturn numeric(18,4)

Select @dblReturn = SUM(AmountCurrentMonthIn) From AT_Materiel_StockBalance Where SortID = @SortID

Return (@dblReturn)

END

调用方法

select dbo.StockBalance_AmountIn(2523)

这里头需要加dbo