自定义函数不能赋值,该如何处理
日期：2014-05-17 浏览次数：20386 次
自定义函数不能赋值
SELECT @ID=ID FROM ReplenishItem WHERE (PromotorPackNo = @PromotorPackNo) AND (ReplenishmentID = @ReplenishID)
这句话中不能给@ID赋值，请问各位大侠，为什么呢？
------解决方案--------------------
SELECT @ID=ID FROM ReplenishItem WHERE (PromotorPackNo = @PromotorPackNo) AND (ReplenishmentID = @ReplenishID)
这句之前你定义了@id这个变量没有？
------解决方案--------------------
函数是对的吧
SELECT ID FROM ReplenishItem WHERE (PromotorPackNo = @PromotorPackNo) AND (ReplenishmentID = @ReplenishID)
这条语句能查询到数据么？
ALTER FUNCTION IsPackInReplenish
(
@PromotorPackNo varchar(32),
@ReplenishID int
)
RETURNS BIT
AS
BEGIN
--DECLARE @PromotorPackNo varchar(32)
--DECLARE @ReplenishID int
--SELECT @PromotorPackNo='YP201401130000'
--SELECT @ReplenishID = 7
DECLARE @Result bit
-- 查找添补明细表中分包是否存在
DECLARE @ID int
SELECT @ID=ID FROM ReplenishItem WHERE (PromotorPackNo = @PromotorPackNo) AND (ReplenishmentID = @ReplenishID)
IF @ID>0
BEGIN
SET @Result = 1
END
ELSE
BEGIN
SET @Result = 0
END
RETURN @Result
END
SELECT @ID=ID FROM ReplenishItem WHERE (PromotorPackNo = @PromotorPackNo) AND (ReplenishmentID = @ReplenishID)
这句话中不能给@ID赋值，请问各位大侠，为什么呢？
------解决方案--------------------
SELECT @ID=ID FROM ReplenishItem WHERE (PromotorPackNo = @PromotorPackNo) AND (ReplenishmentID = @ReplenishID)
这句之前你定义了@id这个变量没有？
------解决方案--------------------
函数是对的吧
SELECT ID FROM ReplenishItem WHERE (PromotorPackNo = @PromotorPackNo) AND (ReplenishmentID = @ReplenishID)
这条语句能查询到数据么？
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
