SQL筛选空值


select * from Translation where TransContent is not null and CONVERT(NVARCHAR(4000),TransContent)!='' and Member='wang_su_fei'

select TransContent from Translation where TransContent is not null and cast(TransContent as NVARCHAR)<>''

posted @ 2012-08-08 18:42  wangsufei  阅读(406)  评论(0编辑  收藏  举报