Home >Database >Mysql Tutorial >SQLserver查询数据类型为ntext是空或NULL值的方法
SQLserver查询数据类型为ntext是空或NULL值的方法
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-07 18:00:58939browse
SQLserver查询数据类型为ntext是空或NULL值的方法
代码如下:
--为空的值text ntext
select * from lf_newsNg_utf where datalength(newsContentE)=0 or datalength(newsContentE) is null
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：sqlserver利用存储过程去除重复行的sql语句Next article：监控 log文件大小的存储过程