如何检查 SQL Server 文本列是否为空?
我使用的是 SQL Server 2005.我有一个带有文本列的表，并且表中有很多行，其中该列的值不为空，但为空.尝试与 '' 进行比较会产生以下响应:
I am using SQL Server 2005. I have a table with a text column and I have many rows in the table where the value of this column is not null, but it is empty. Trying to compare against '' yields this response:
数据类型 text 和 varchar 在不等于运算符中不兼容.
The data types text and varchar are incompatible in the not equal to operator.
是否有特殊函数可以判断一个文本列的值是否为空而是空?
Is there a special function to determine whether the value of a text column is not null but empty?
推荐答案
where datalength(mytextfield)=0
相关文章