数据表有个字段Up是Boolean类型，sql后面where条件要等于false，如何写？
"Select * FROM Company order by UpdateTime WHERE Up=false "

这样写错了。。要怎么写？

[解决办法]
Accesss

"Select * FROM Company WHERE Up=true order by UpdateTime "
"Select * FROM Company WHERE Up=false order by UpdateTime "


SQL Server 通常选择 bit 类型，对应 .net 中类型 即 Boolean，但 sql 语句使用 1 和 0

"Select * FROM Company WHERE Up=1 order by UpdateTime "
"Select * FROM Company WHERE Up=0 order by UpdateTime "


[解决办法]
jf,肯承认错误的是好孩子~~
[解决办法]
SQL 用01
ACCESS才用ture false