怎样可以把某字段为空的所有记录查找出来？(50分)

D

d_delphi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-04

• #1

怎样可以把某字段为空的所有记录查找出来？

 

S

snjat

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-04

• #2

select * from table where field is null

 

D

d_delphi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-04

• #3

接受答案了.

 

G

gong666

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-04

• #4

MS SQL:
select fileld1 from table1 where field1 is NULL

 

B

book523

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-04

• #5

sql 2000
楼上的可以