"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