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)<>''

转载于:https://www.cnblogs.com/wangsufei/archive/2012/08/08/2628827.html