text字段为空查询

来源:互联网 发布:北京经纬恒润科技 知乎 编辑:程序博客网 时间:2024/03/28 20:27
SELECT     TOP (200) bh, factory, cargo, clientcargo, bedcolor, bedsize, category, opdate, finished, outboxnumber, outanumber, outunit, excode, ifdapei,
                      tradecompany, needlemachine, needle1, needle2, bz, jzdapei, otherbnumber, washbnumber, jpremainder, remainder, nbnumber, classnumber,
                      opcontent, jianpin, nanumber, confirmdate, opconfirm
FROM         outbh
WHERE     (DATALENGTH(bz) <> 0)
原创粉丝点击