求判断数据库栏位是否为空和null语句

reallylovesky 2007-08-28 10:52:55

if (select T_EXP_ORDER.CNTT_NO FROM T_EXP_ORDER INNER JOIN
T_AC_EXP_ACHIEVE ON
T_EXP_ORDER.PROD_CLASS_ID = T_AC_EXP_ACHIEVE.PROD_CLASS_ID INNER
JOIN
T_PROD_CLASS ON
T_EXP_ORDER.PROD_CLASS_ID = T_PROD_CLASS.PROD_CLASS_ID )=''
begin
PRINT 'S'
end
else
PRINT 'T'
我想T_EXP_ORDER.CNTT_NO判断他的栏位为=‘’和null显示S
否的时候显示T
怎么同时满足null和‘’

...全文

243 11 打赏收藏转发到动态举报

写回复

用AI写文章

11 条回复

切换为时间正序

请发表友善的回复…

发表回复

reallylovesky 2007-08-28

打赏
举报

怎么样用一个栏位输出？？？？

reallylovesky 2007-08-28

打赏
举报

谢谢大家了！

dawugui 2007-08-28

打赏
举报

不存在.not exist
或用leo_lesley(leo) 的isnull

reallylovesky 2007-08-28

打赏
举报

leo_lesley(leo) OK
dawugui(潇洒老乌龟) 有问题

lost_queen 2007-08-28

打赏
举报

乌龟大哥的代码没有看懂～
啥意思啊？

dawugui 2007-08-28

打赏
举报

if not exist (select T_EXP_ORDER.CNTT_NO FROM T_EXP_ORDER INNER JOIN
T_AC_EXP_ACHIEVE ON
T_EXP_ORDER.PROD_CLASS_ID = T_AC_EXP_ACHIEVE.PROD_CLASS_ID INNER
JOIN
T_PROD_CLASS ON
T_EXP_ORDER.PROD_CLASS_ID = T_PROD_CLASS.PROD_CLASS_ID )
begin
PRINT 'S'
end
else
PRINT 'T'

leo_lesley 2007-08-28

打赏
举报

if isnull(select T_EXP_ORDER.CNTT_NO FROM T_EXP_ORDER INNER JOIN
T_AC_EXP_ACHIEVE ON
T_EXP_ORDER.PROD_CLASS_ID = T_AC_EXP_ACHIEVE.PROD_CLASS_ID INNER
JOIN
T_PROD_CLASS ON
T_EXP_ORDER.PROD_CLASS_ID = T_PROD_CLASS.PROD_CLASS_ID,'')=''
begin
PRINT 'S'
end
else
PRINT 'T'

数字化从业者老高 2007-08-28

打赏
举报

if (select ISNULL(T_EXP_ORDER.CNTT_NO,'') FROM T_EXP_ORDER INNER JOIN
T_AC_EXP_ACHIEVE ON
T_EXP_ORDER.PROD_CLASS_ID = T_AC_EXP_ACHIEVE.PROD_CLASS_ID INNER
JOIN
T_PROD_CLASS ON
T_EXP_ORDER.PROD_CLASS_ID = T_PROD_CLASS.PROD_CLASS_ID )=''
begin
PRINT 'S'
end
else
PRINT 'T'

reallylovesky 2007-08-28