Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SqlserverÓëaccessÊý¾Ý¿âsqlÓ﷨ʮ´ó²îÒì

ÊÀʶ´Ã÷½ÔѧÎÊ£¬ÈËÇéÁ·´ï¼´ÎÄÕ¡£×öASPʱ£¬×î³£ÓõÄÊý¾Ý¿â¼´SqlserverÓëAccessÊý¾Ý¿âĪÊôÁË£¡
µ«Ê¹Óûᾭ³£·¢ÏֺܶàSQLÖ´ÐеÄÎÊÌâ¡£ÕâÀïÕûÀí³öÖ®¼äµÄ²îÒ죬×ö¸öÊ®´ó²îÒìµÄ×ܽᡣ
ACCESS½á¹¹¼òµ¥ÈÝÒ×´¦Àí£¬¶øÇÒÒ²ÄÜÂú×ã¶àÊýµÄÍøÕ¾³ÌÐòÒªÇó£¬Ò²ÊdzõѧÕßµÄÊÔÅ£µ¶¡£
ACCESSÊÇСÐÍÊý¾Ý¿â£¬¼ÈÈ»ÊÇСÐ;ÍÓÐËû¸ù±¾µÄ¾ÖÏÞÐÔ£º
1£©¡¢Êý¾Ý¿â¹ý´ó£¬Ò»°ãACCESSÊý¾Ý¿â´ïµ½50M×óÓÒµÄʱºòÐÔÄܻἱ¾çϽµ£¡
2£©¡¢ÍøÕ¾·ÃÎÊÆµ·±£¬¾­³£³¬¹ý100È˵ÄÔÚÏßʱ£¬´¦ÀíËÙ¶È»áÓÐÓ°Ï죡
3£©¡¢¼Ç¼Êý¹ý¶à£¬Ò»°ã¼Ç¼Êý´ïµ½10ÍòÌõ×óÓÒµÄʱºòÐÔÄܾͻἱ¾çϽµ£¡
΢Èí¹«Ë¾ÎªÁËÓëACCESS¸ßµÍ´îÅäµÄÒ»Öָ߶˷½°¸£º¸ÄÓÃÁËSqlserver£¬µ«Óï·¨»áÓÐһЩ²îÒì¡£
1¡¢select£¬updateÓï¾äÇø±ð
select£¬update¶ÔÓÚµ¥±í²Ù×÷ʱ»ù±¾Ò»Ö¡£  
µ«¶à±í²Ù×÷ʱupdateÓï¾äµÄÇø±ðACCESSÓëSQLSERVERÖеÄUPDATEÓï¾ä»áÓвî±ð£º
SQLSERVERÖиüжà±íµÄUPDATEÓï¾ä£º  
   UPDATE Table1 SET a.Name = b.Name from Table1 a, Table2 b WHERE a.ID = b.ID;  
ACCESSÖÐͬÑù¹¦ÄܵÄSQLÓï¾ä:
   UPDATE Table1 a, Table2 b SET a.Name = b.Name WHERE a.ID = b.ID;
±È½ÏµÃ³ö£ºACCESSÖеÄUPDATEÓï¾äûÓÐfrom×Ó¾ä,ËùÓÐÒýÓÃµÄ±í¶¼ÁÐÔÚUPDATE¹Ø¼ü×Öºó£¬Õâµãͬmysql;  
2¡¢deleteÓï¾ä  
   SQLSERVERÖУºDELETE from Table1 WHERE ID > 1;
   AccessÖУºDELETE * from Table1 WHERE ID > 1;
±È½ÏµÃ³ö£ºSQLSERVERÖУ¬¼´Ö»Òª°ÑselectÓï¾äÀïµÄselectÓëdeleteµÄ²Ù×÷Óï·¨Ò»Öµģ¬²»ÐèÒª*£»
  
3¡¢asºóÃæµÄ¼ÆËã×Ö¶ÎÇø±ð
   SQLSERVERÖУºSELECT a.sum(num) as sum_num, sum(num)*num as all_num;   ¼´  
   AccessÖÐ:     SELECT a,sum(num) as sum_num, sum_num*num   as all_num;   ¼´
±È½ÏµÃ³ö£º
SQLSERVERÖУº²»¿ÉÒÔ°ÑASºóµÄ×ֶε±×÷Ò»¸öÊý¾Ý¿â×ֶβÎÓë¼ÆËã¡£
AccessÖÐ: ¿ÉÒÔ°ÑASºóµÄ×ֶε±×÷Ò»¸öÊý¾Ý¿â×ֶβÎÓë¼ÆËã¡£  
4¡¢¡¸.¡¹Ó롸!¡¹µÄ²îÒì
   SQLSERVERÖУºSELECT Table1.a AS Table1a, Table2.b AS Table2b from Table1, Table2;
   AccessÖУº   SELECT Table1!a AS Table1a, Table2!b AS Table2b from Table1, Table2;
±È½ÏµÃ³ö£º
¡¸!¡¹Ê¹


Ïà¹ØÎĵµ£º

ÓÃSQLÓï¾äµÃµ½SQLServer µÄ±íÖеÄÁеÄÃèÊöÖµ

 select   case   when   c.colid=1   then   object_name(c.id)   else   ''   end   as   ±íÃû    
  ,c.name   as   ×Ö¶ÎÃû  
  ,t.name   Êý¾ÝÀàÐÍ  
  ,c.prec   as   ³¤¶È   ......

SQLʹÓÃС½á

1. Èç¹ûÄãÏ£ÍûʹÓÃselcet topÓï¾ä£¬²¢ÇÒ»¹Òª¸½´øwhereÌõ¼þ£¬ÄÇôÌõ¼þÖеÄÁо͵ÃÊǺÏÊʵÄË÷Òý£¬Èç¾Û¼¯Ë÷Òý¡¢¸´ºÏË÷ÒýÀïµÄÖ÷ÁÐ
 µÈ£¬Í¬Ê±£¬whereÌõ¼þÀïÒ²Òª¾¡Á¿±Ü¿ªÊ¹Óú¯Êý£¬or£¬ÅжÏNULLµÈ»áÒýÆðÈ«²¿É¨ÃèµÄÓï¾ä£¬²»È»Ö´ÐеÄÊÇÈ«±íɨÃè¡£
2. ͨ¹ýÉèÖÃSTATISTICSÎÒÃÇ¿ÉÒԲ鿴ִÐÐSQLʱµÄÖ´ÐÐЧÂÊÒÔ¼°Ïà¹ØÐÔÄܲâÊÔ ......

Access Code Fingerprint Door Lock

 HTML clipboard
Presidential edition double action fingerprint and access code security door
lock for your office, business or home. Get 100% safety at your entry point with
this maximum security style deadbolt double action lock.
This is one of the best and most secure methods in assuri ......

sqlÖеÄÓαê

declare @id varchar(10)
declare @nm varchar(10)
declare @table as table(emp varchar(10),empname varchar(10))
declare CurEmp cursor for select top 6 empid,empname from employee
open CurEmp
fetch next from CurEmp into @id,@nm
While @@fetch_status=0
 begin
  insert @table(emp,e ......

SQL SERVER Ò×»ìÏýµÄÊý¾ÝÀàÐÍ

 (1)char¡¢varchar¡¢textºÍnchar¡¢nvarchar¡¢ntext
charºÍvarcharµÄ³¤¶È¶¼ÔÚ1µ½8000Ö®¼ä£¬ËüÃǵÄÇø±ðÔÚÓÚcharÊǶ¨³¤×Ö·ûÊý¾Ý£¬¶øvarcharÊDZ䳤×Ö·ûÊý¾Ý¡£Ëùν¶¨³¤¾ÍÊdz¤¶È¹Ì¶¨ µÄ£¬µ±ÊäÈëµÄÊý¾Ý³¤¶ÈûÓдﵽָ¶¨µÄ³¤¶Èʱ½«×Ô¶¯ÒÔÓ¢ÎĿոñÔÚÆäºóÃæÌî³ä£¬Ê¹³¤¶È´ïµ½ÏàÓ¦µÄ³¤¶È£»¶ø±ä³¤×Ö·ûÊý¾ÝÔò²»»áÒÔ¿Õ¸ñÌî³ä¡£ text´ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ