数据库问题,实在想不通...
select count(*) from table_name where siteid in (0,1,2,3,4,5,6,7,8,9) 结果:312
select count(*) from table_name where siteid not in (0,1,2,3,4,5,6,7,8,9) 结果:0
select count(*) from table_name 结果:1005
是在企业管理器里执行的,数据库里应该是1005条记录,您说该怎么办??
table_name是一视图
siteid int型,初始值是0