函数如下
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
|