TSQL : Compare variable with integer when variable is nothing
来源:互联网 发布:林弯弯淘宝店铺 编辑:程序博客网 时间:2024/04/30 16:50
IF(
(@FCCPROCESSSTATUS <>0 AND NOT(@FCCPROCESSSTATUS = 2 AND ISNULL(@DCCFLOWVERSION,0) = 2))
--(@FCCPROCESSSTATUS <>0 AND NOT(@FCCPROCESSSTATUS = 2 AND @DCCFLOWVERSION = 2))
OR (@FOREIGNAMOUNT IS NOT NULL)
)
BEGIN
Print 'DCCFlow : ' + cast( @DCCFLOWVERSION as varchar(10)) + '!!'
END
ELSE
BEGIN
Print 'DCCFlow : nothing '
END
NOTE: when @DCCFLOWVERSION is nothing(not null) , the first branch will not be reached!!!!
so the fix is the line highlighted in RED.
- TSQL : Compare variable with integer when variable is nothing
- What is volatile variable in Java - When to use
- Is there a way to loop through a table variable in TSQL without using a cursor?
- Variable
- Variable
- variable
- variable
- Variable 'innodb_log_buffer_size' is a read only variable
- Platform Builder: Cesysgen.bat, what happens when a SYSGEN Variable is set?
- Formatting messages with variable content
- Concurrent list with condition variable
- Linear regression with one variable
- Linear Regression with One Variable
- Linear regression with one variable
- [VB.NET]Object variable or With block variable not set
- ErrorList:Object variable or With block variable not set error
- protobuf中的variable-integer编码方式
- Calls with a Variable Number of Arguments
- Computer Terms
- 60个开发者不容错过的免费资源库
- poj 1016 Numbers That Count
- Nginx 常见应用技术指南
- LeetCode - Word Ladder II
- TSQL : Compare variable with integer when variable is nothing
- “git add” 撤销 ?还没有运行 "git commit"
- nginx+resin session 问题解决
- Adnroid 简单获取服务器图片以及网页源码查看器
- android中的短信sqlite库中,通过命令读取
- Ubuntu 安装Google Chrom
- 多做更要多说
- nginx Location,rewrite,防盗链,禁止访问
- Linux串口读写