mssql和access 中bit类型的值取反怎么操作对比

ACCESS 的sql 语句: Update [wd_no_Filters] set wt_PublicTf =Not wt_PublicTf

SQL2000里的语句:Update [wd_no_Filters] set wt_PublicTf = abs(wt_PublicTf-1) 

More...