from: http://msdn.microsoft.com/en-us/library/aa175795%28SQL.80%29.aspx

 

1 

--

为空的值text ntext 

2 

select

 

*

 

from

 lf_newsNg_utf 

where

 

datalength

(newsContentE)

=

0

 

or

 

datalength

(newsContentE) 

is

 

null

3