1.1算出日期差:
1.access: datediff('d',fixdate,getdate())
2.sqlserver: datediff(day,fixdate,getdate())
ACCESS实例: select * from table where data=datediff('d',fixdate,getdate())
sqlserver实例: select * from table where data=datediff(day,fixdate,getdate())
2、日期变量
1.access: #"&data&"#
2.sqlserver: '"&data&"'
ACCESS实例: select * from table where data=#"&data&"#
sqlserver实例: select * from table where data='"&data&"'
----------------------------------------------------------------------------
3、是否
1.access: not finished
2.sqlserver: finished=0
ACCESS实例: select * from table where not finished
sqlserver实例: select * from table where finished=0
----------------------------------------------------------------------------
4、求余数
1.access: a mod b=100
2.sqlserver: a % b =100
ACCESS实例: select a mod b=100 from table where not finished
sqlserver实例: select a % b =100 from table where finished=0
----------------------------------------------------------------------------