SQL编程问题

Question

borrowID   stuID      BID        T_time                  B_time
---------- ---------- ---------- ----------------------- -----------------------
T001       1001       B001       2007-12-26 00:00:00.000 NULL
T002       1004       B003       2008-01-05 00:00:00.000 NULL
T003       1005       B001       2007-10-08 00:00:00.000 2007-12-25 00:00:00.000
T004       1005       B002       2007-12-16 00:00:00.000 2008-01-07 00:00:00.000
T005       1002       B004       2007-12-22 00:00:00.000 NULL
T006       1005       B005       2008-01-06 00:00:00.000 NULL
T007       1002       B001       2007-09-11 00:00:00.000 NULL
T008       1005       B004       2007-12-10 00:00:00.000 NULL
T009       1004       B005       2007-10-16 00:00:00.000 2007-12-18 00:00:00.000
T010       1002       B002       2007-09-15 00:00:00.000 2008-01-05 00:00:00.000
T011       1004       B003       2007-12-28 00:00:00.000 NULL
T012       1002       B003       2007-12-30 00:00:00.000 NULL表名：borrow
在这个表中我要查询B_Time为null的信息怎么查列？
select * from borrow where B_Time = null
查不出来东西啊

Answer 1

select * from borrow where B_Time is null 

Answer 2

select * from borrow where B_Time is null

Answer 3

SELECT * FROM borrow WHERE B_Time IS NULL
Or
SELECT * FROM borrow WHERE ISNULL(B_Time,0)=0