sql server 2012函数错误 [英] sql server 2012 error in function

问题描述

大家好，



我在sql server 2012中执行以下语句，但收到的错误是语法不正确>

Hi all,

I am executing following statements in sql server 2012 but am getting error saying that "Incorrect syntax near >"

DECLARE @NUMBER INT=10
SELECT IIF(@NUMBER >10,'TRUE','FALSE') AS DD

任何人都可以帮我解决这个问题。



谢谢和问候，

Prakash.ch

could anyone help me to resolve this problem.

Thanks and Regards,
Prakash.ch

推荐答案

试试这个...... :)

try this...:)

DECLARE @NUMBER INT=10
SELECT CASE
WHEN @NUMBER > 10 THEN 'TRUE'
ELSE 'FALSE' END AS DD;

尝试使用以下代号作为替代方案



选择案例时@NUMBER> 10那么'正确''错误'结束

Try with bellow code as alternative

SELECT CASE WHEN @NUMBER > 10 THEN 'TRUE' ELSE 'FALSE' END

这篇关于sql server 2012函数错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！