函数如下
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
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18