如何查询非空的行

[kvkensinb]

sql通常都是查列非空的，有没办法查行非空的？谢谢

[黄_瓜]

--1
where col is not null
--2
where col !=''
--3
where col is not null and col !-''

[jiao3630]

[Quote=引用 1 楼 beirut 的回复:]
SQL code
--1
where col is not null
--2
where col !=''
--3
where col is not null and col !-''
[/Quote]
+1

[chuifengde]

1.把行变成列，查非空列
2.用函数判断行的结果再作为查询条件

[王向飞]

col1 is not null and col2 is not null and col3 is not null

[jiao3630]

3貌似应该是

where col is not null and col !=''

[黄_瓜]

行非空呀

where cast(col as sql_variant)
+cast(co2 as sql_variant)
+cast(co3 as sql_variant)
is not null

这样？？

[dawugui]

[Quote=引用楼主 kvkensinb 的回复:]
sql通常都是查列非空的，有没办法查行非空的？谢谢
[/Quote]
select * from tb where col1 is not null and col2 is not null .....

[claro]

set ansi_null off

select * from tb where col1 <> null and col2 <> null .....

set ansi_null on

select * from tb where col1 is not null and col2 is not null .....

[ask_chang]

笨方法：

一列一列判断非空

[abuying]

--自身左连接 ，查询 is null记录。

select a.* from tb a left join tb b on a.[col1]=b.[col1] where b.[col1] is null