标题: ??????Access???????¨????SqLServer??--zt [打印本页]

---

作者: zing    时间: 2005-9-11 20:30     标题: ??????Access???????¨????SqLServer??--zt

??????Access???????¨????SqLServer??


?????????á???????????ò???¨????????????????????????????????·?????windows2000??IIS5??????????????????????Access?????????±?????????????¨????windows2003?????ó??·?????????????????????????????????×????????í???¤?????????à????????i???ú??????Access???????????????????????????????×?????????????í????????????????????×???????????????????Access???°??·???????????????·?±??????????¨?¨????SQl????
??????????????????SQL Server
  ????SQL Server?ó?????í?÷?????¨???????????????ó????????????????????Access??????×÷???????????????ù??????????
????????????????±í
  ?¨??????·????¨????????±í?????????÷?ü??????????????????????Access???????÷??±í???¨????±???·??????????¨??×????ò???ó???????ò???á????????????????
???????????????ò

  ???????¨?????à????·????÷?????¨???????????×??,????????????????????.????Access??????????????SqL?????????????????ù???ù???????ò?ᱨ?í???ù?????ò??±¨?í?????????à??????·????????÷??????????????·???

SqL????????Now?¨????????
??Access??????Now?¨?????????????±?°?±????????SQL Server????Getdate?¨?????????????±?°?±???????????????????????ò??????vb Script??????VbScript????????Now?¨???????????±?°?±?????ù????????Sql????????Datediff??????????????????

??Access??DateDiff????????????????????????????????×?????±í??±???????·???????SqLServer?????è?????????????????????ò???ò????±í?????????ò??????????×???????

???ê?ó???????????????ù?????í?ó?¨?????ò????????

???ò???????????????????°?ó?±???????¨??4???à???±°???

????????????????
    1??????????????????Access???????????????ó?¨??·?±???????????????±??????????????????????????à?????ò??????????????SQL??????????????????????????????????±??????????????????????????????????????ú?????è???÷????×???±ê??????±??????ó?¨????
   2?????????è?????ò?±?ò??????·??????????????¨?????è?????????????????é???????????????±?ò??????????±ê×???SqL??·¨???????????á??·????????????????????????????????á?????????????ù×????????ó???????????á????????

---

欢迎光临 我要委托设计网论坛 (http://51odm.com/fourms/)

Powered by Discuz! 5.5.0