1.ACCESSçæ°æ®åºä¸çèªå¨ç¼å·ç±»åå¨è½¬åæ¶ï¼sql server并没æå°å®è®¾ä¸ºèªå¨ç¼å·åï¼æ们éå¨SQLå建è¯å¥ä¸å ä¸identityï¼è¡¨ç¤ºèªå¨ç¼å·ï¼
2.转åæ¶ï¼è·æ¥ææå
³çå段ï¼SQL SERVERé»è®¤ä¸ºsmalldatetimeåï¼æ们æ好å°å®å为datetimeåï¼å 为datetimeåçèå´æ¯smalldatetimeå大ãæéè§è¿ç§æ
åµï¼ç¨smalldatetimeåæ¶ï¼è½¬å失败ï¼èç¨datetimeåæ¶ï¼è½¬åæåã
3.对æ¤ä¸¤ç§æ°æ®åºè¿è¡æä½çsqlè¯å¥ä¸å
¨ç¸åï¼ä¾å¦ï¼å¨å¯¹ACCESSæ°æ®åºè¿è¡å é¤çºªå½æ¶ç¨ï¼%22delete * from user where id=10%22,è对SQL SERVERæ°æ®åºè¿è¡å é¤æ¯ç¨ï¼%22delete user where id=10%22.
4.æ¥æå½æ°ä¸ç¸åï¼å¨å¯¹ACCESSæ°æ®åºå¤çä¸ï¼å¯ç¨date()ãtime()çå½æ°ï¼ä½å¯¹SQL SERVERæ°æ®åºå¤çä¸ï¼åªè½ç¨datediff,dateaddçå½æ°ï¼èä¸è½ç¨date()ãtime()çå½æ°ã
5.å¨å¯¹ACCESSæ°æ®åºå¤çä¸,sqlè¯å¥ä¸ç´æ¥å¯ä»¥ç¨ä¸äºVBçå½æ°ï¼åcstr()å½æ°ï¼è对SQL SERVERæ°æ®åºå¤çä¸ï¼å´ä¸è½ç¨ã1ï¼å¯¹äºæ¥æå段å段
access表示为ï¼#1981-28-12#
SQLSERVER2000表示为ï¼ââ1981-02-12ââ
2,SQLè¯å¥åºå«ï¼select ,update å¨å¯¹å表æä½æ¶é½å·®ä¸å¤ï¼
ä½å¤è¡¨æä½æ¶updateè¯å¥çåºå«ACCESSä¸SQLSERVERä¸çUPDATEè¯å¥å¯¹æ¯:
SQLSERVERä¸æ´æ°å¤è¡¨çUPDATEè¯å¥:
UPDATE Tab1
SET a.Name = b.Name
FROM Tab1 a,Tab2 b
WHERE a.ID = b.ID;
åæ ·åè½çSQLè¯å¥å¨ACCESSä¸åºè¯¥æ¯
UPDATE Tab1 a,Tab2 b
SET a.Name = b.Name
WHERE a.ID = b.ID;
å³:ACCESSä¸çUPDATEè¯å¥æ²¡æFROMåå¥,ææå¼ç¨ç表é½åå¨UPDATEå
³é®åå.
æ´æ°å表æ¶ï¼é½ä¸ºï¼
UPDATE table1 set ab=â12â,cd=444 where â¦.
3,deleteè¯å¥
accessä¸å é¤æ¶ç¨:delete * from table1 where a>2 å³åªè¦æselect è¯å¥éçselect æ¢ædeleteå°±å¯ä»¥äºã
sqlserve ä¸å为: delete from table1 where a>2 å³æ²¡æ*å·ä¸å½2006-4-15 19:27:48
4ï¼as åé¢ç计ç®å段åºå«
accessä¸å¯ä»¥è¿æ ·ï¼select a,sum(num) as kc_num,kc_num*num as all_kc_num å³å¯ä»¥æASåçå段å½ä½ä¸ä¸ªæ°æ®åºå段åä¸è®¡ç®ã
sqlserver ä¸å为ï¼select a,sum(num) as kc_num,sum(num)*num as all_kc_num å³ä¸å¯ä»¥æASåçå段å½ä½ä¸ä¸ªæ°æ®åºå段åä¸è®¡ç®ã
5ï¼[.]ä¸[!]çåºå«
accessä¸å¤è¡¨èåæ¥è¯¢æ¶ï¼select tab1!a as tab1a,tab2!b tab2b from tab1,tab2 ,ä¸é´çASå¯ä»¥ä¸è¦ã
sqlserve ä¸åï¼select tab1.a as tab1a,tab2.b tab2b from tab1,tab2 ,ä¸é´çASå¯ä»¥ä¸è¦ã
6,èåæ¥è¯¢æ¶ï¼
accessä¸å¤è¡¨èåæ¥è¯¢:âselect a,b from(
select a,b from tab1 where a>3 union select c,d from tab2 ) group by a,b
sqlserve ä¸åâselect a,b from(
select a,b from tab1 where a>3 union select c,d from tab2 ) tmptable group by a,bå³è¦å ä¸ä¸ªèç表tmptableï¼è¡¨åä»»æãâ
7ï¼accesså级å°sqlserveræ¶ï¼
å¯ä»¥ç¨sqlserverçæ°æ®å¯¼å
¥å·¥å
·å¯¼å
¥æ°æ®
温馨提示:答案为网友推荐,仅供参考