函数错误[在函数内无效使用副作用运算符'select'] [英] Function error [invalid use of side-effecting operator 'select' within a function]

问题描述

任何人都可以帮助我在sql server 2012中创建函数吗，我在sql中是新的，它显示错误[在函数中无效地使用了副作用运算符选择"]

创建函数Get_RearEnd_Outflow(@I_TXN_ID INT)
返回int
始于
宣告@V_COUNT INT
从IRR_CHARGES_M选择COUNT(*)INTO @V_COUNT
返回@V_COUNT
END

Can any one help me to create function in sql server 2012 ,I M new in sql it shows error [invalid use of side-effecting operator ''select'' within a function]

CREATE FUNCTION Get_RearEnd_Outflow( @I_TXN_ID INT)
RETURNS int
AS BEGIN
DECLARE @V_COUNT INT
SELECT COUNT(*) INTO @V_COUNT FROM IRR_CHARGES_M
RETURN @V_COUNT
END

推荐答案

更改选择，如下所示，然后尝试.

Change select as shown below and then try.

SELECT @V_COUNT=COUNT(*) FROM IRR_CHARGES_M

这篇关于函数错误[在函数内无效使用副作用运算符'select']的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！