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

SQL Server CE

 SQL Server CE 2.0µÄÈ«ÃûÊÇSQL Server 2000 Windows CE Edition version 2.0¡£
Àý×Ó1£º¹«Ë¾ÅÉÈËÈ¥²Ö¿âÑé»õ¡¢µã»õ£¬¿ÉÒÔ°ÑÇ嵥ͬ²½µ½Pocket PCÉÏ£¬È»ºóÔÚ²Ö¿âÀïÃæÖ±½ÓÔÚPPCÉÏÃæupdate£¬»Øµ½¹«Ë¾Ò»Í¬²½¾Í¿ÉÒÔÁË¡£·ñÔò°´ÕÕÔ­ÏÈ×ö·¨£¬ÐèÒªÏÈ´òÓ¡Ò»ÕÅÇåµ¥£¬»ØÀ´ÒÔºóÔÙ¼ÈëÒ»±é¡£
Àý×Ó2£ºÁªÏëÅÉÈËÉÏÃÅÀ´ÐÞµçÄÔ£¬ÒÔǰ×ÜÊÇ´ø×ÅÒ»ÕÅ´òÓ¡³öÀ´µÄÅɹ¤µ¥£¬Î¬ÐÞÍíÁËÒÔºóάÐÞµÄÈËÌîдάÐ޼Ǽ£¬È»ºóÈÿͻ§Ç©×Ö¡£ÕâÑù×ö£¬Ò»ÔòÊÇÖ½ÖÊÅɹ¤µ¥µÄµµ°¸¹ÜÀíºÜÂé·³£¬¶þÔòάÐ޼ǼµÈÍ£ÁôÔÚÖ½ÉÏ£¬Èç¹ûÏëÓÃ×÷֪ʶ¹ÜÀí¡¢Business IntelligenceµÈ¸ü¶à·ÖÎöÓÃ;£¬»¹ÐèÒªÔÙÕÒÈËÊäÈë¡£Èç¹ûÄܰÑÅɹ¤µ¥Í¬²½µ½Pocket PCÀïÃæ£¬ÔÚÏÖ³¡Ö±½ÓÌîд¼Ç¼ÒÔ¼°Èÿͻ§Ç©×Ö£¬»ØÀ´Ò»ÏÂ×Óͬ²½µ½·þÎñÆ÷ÉÏ£¬¾Í·½±ã¶àÁË¡£
1. SQL CEµÄ¼Ü¹¹
Ê×ÏÈÒª»Ø´ðµÄÎÊÌâÊÇ“SQL CEÊÇʲô”¡£¼òµ¥µÄ˵£¬SQL CE¾ÍÊÇÔËÐÐÔÚPocket PCÒÔ¼°ÆäËûWindows CEƽ̨ÉϵÄÒ»¸öºÜ¼ò»¯µÄSQL Server 2000/7.0¡£Ö®ËùÒÔ˵ÊÇ“¼ò»¯”µÄ£¬ÒòΪËüÖ§³ÖµÄ¹¦ÄÜÉÙ¡¢Êý¾ÝÀàÐͱȽÏÉÙ¡¢Öܱ߹¤¾ßÒ²ÉÙ¡£³ýÁËÔËÐÐÔÚDeviceÉϵIJ¿·ÖÒÔÍ⣬SQL CE»¹´øÁËÒ»Ì׿ª·¢°ü£¨¾ÍÊÇSqlce Data Provider£©£¬ÒÔ¼°SQL CE Server ToolÓÃÀ´Á¬½Ó·þÎñÆ÷ÉϵÄSQL Server 2000/7.0£º
¿ª·¢Ê±£¬¿ÉÒÔÓÃVS.NET»òÕßeVB/eVCÀ´¿ª·¢¡£Èç¹ûÓÃeVB/eVC¿ª·¢£¬¾ÍÓÃADOCE 3.1£»Èç¹ûÓÃ.NET¿ª·¢£¬¾ÍÓÃ.NET Compact FrameworkÒÔ¼°SQL Server CE Data Provider£¬Ó÷¨»ù±¾ÉϺÍÔ­ÏȵÄADO.NETûɶ̫´óµÄÇø±ð£º
ÔËÐÐʱ£¬SQL CEµÄ¸Ð¾õ¾ÍºÃÏñÊÇSQL Server 2000/7.0µÄÒ»¸ö¸±±¾£¬SQL CEÓ¦ÓóÌÐò±¾ÉíÔÚPocket PCÉÏ»áÕ¼ÓÃ1-3MB¿Õ¼ä£¬ÁíÍâÊý¾Ý»Ø´æ·ÅÔÚºó׺ÃûΪ.sdfµÄÎļþÖУ¨ºÍSQL2KÖеÄmdfÎļþͬÑùµÄ½ÇÉ«£©¡£Óû§ÔÚPocket PCÉÏ×öµÄ²Ù×÷¶¼ÏÈ·¢ÉúÔÚSQL CEÉÏ£¬È»ºóÔÙʱ²»Ê±µØºÍSQL Server 2000/7.0ͬ²½£¨Replication£©¡£µ±È»£¬Ò²¿ÉÒÔÓÃRDA£¨Remote Data Access£©µÄ·½Ê½£¬Ö±½ÓÈÃÊý¾Ý²Ù×÷·¢ÉúÔÚSQL Server 2000/7.0ÉÏ¡£
ÕâÀïÒ»¸öÓÐÒâ˼µÄµØ·½ÊÇÎÞÂÛÓÃReplication»¹ÊÇRDA£¬Òƶ¯É豸·ÃÎÊSQL Server 2000/7.0ʱ±ØÐëͨ¹ýIIS½øÐУ¬²»ÖªµÀÕâ¸öÉè¼ÆÊÇ·ñ¿¼ÂÇÁËWeb Server»á·ÅÔÚDMZÀïÃæ¶øSQL»á·ÅÔÚInternalµÄÔ­Òò£º
2. SQL CEµÄ°²×°
Èç¹ûÎÒûÓмǴíµÄ»°£¬SQL Server CE 2.0ÊÇÃâ·ÑµÄ£¬Ö»ÒªÓÐSQL2K Standard/EnterpriseµÄLicense£¬¾Í¿ÉÒÔÏÂÔØ°²×°Ê¹Óᣲ»¹ýÈç¹û×öÉÌÒµ¿ª·¢£¬×îºÃÔÙºËʵһÏ¡£
ÓÐÐËȤµÄ¿ÉÒÔÔÚhttp://www.microsoft.com/sql/ce/downloads/ce20.aspÏÂÔØSQL Server


Ïà¹ØÎĵµ£º

sqlÖн«×Ö¶Îת³ÉDecimal


update CHELIANG_MINGDAN set clmd_yunxuzaizhong = cast(clmd_yunxuzaizhong/1000 as decimal(14,4)) where clmd_yunxuzaizhong is not null
update CHELIANG_MINGDAN set clmd_carweight = cast(clmd_carweight/1000 as decimal(14,4)) where clmd_carweight is not null ......

SQLÈÕÆÚ¸ñʽ»¯Ó¦ÓôóÈ«

Sql Server ÖÐÒ»¸ö·Ç³£Ç¿´óµÄÈÕÆÚ¸ñʽ»¯º¯Êý
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
Select CONVERT(varchar(100), GE ......

Oracle:pl/sql Òì³£´¦Àí[ת]


pl/sql ÌṩÁËÇ¿´ó¶øÁé»îµÄÊÖ¶ÎÀ´²¶×½ºÍ´¦Àí³ÌÐò²úÉúµÄÒì³££¬´Ó¶øÊ¹ oracle µÄÓû§Ô¶ÀëһЩÁîÈË·³ÄÕµÄ bug ¡£
 
pl/sql Òì³£´¦ÀíµÄ¸ÅÄîºÍÊõÓï
 
ÔÚ oracle ÖÐËùÓеĴíÎó¶¼±»ÈÏΪÊDz»Ó¦¸Ã·¢ÉúµÄÒì³£¡£Ò»¸öÒì³£¿ÉÄÜÊÇÒÔÏ 3 ÖÖÇé¿öµÄÒ»ÖÖ£º
u       ÓÉϵͳ²úÉúµÄ´íÎó£¨& ......

SQL ×óÍâÁ¬½Ó£¬ÓÒÍâÁ¬½Ó£¬È«Á¬½Ó£¬ÄÚÁ¬½Ó

 Áª½ÓÌõ¼þ¿ÉÔÚ   from   »ò   WHERE   ×Ó¾äÖÐÖ¸¶¨£¬½¨ÒéÔÚ   from   ×Ó¾äÖÐÖ¸¶¨Áª½ÓÌõ¼þ¡£WHERE   ºÍ   HAVING   ×Ó¾äÒ²¿ÉÒÔ°üº¬ËÑË÷Ìõ¼þ£¬ÒÔ½øÒ»²½É¸Ñ¡Áª½ÓÌõ¼þËùÑ¡µÄÐС£   
   
Áª½Ó¿É·ÖΪÒÔϼ¸Àࣺ      ......

SQL Server Ë«»úÈȱ¸1(based on log shipping)

        ÈÕÖ¾´«ËÍÊÇSQL SERVER2000ÆóÒµ°æ½øÐÐË«»úÈȱ¸µÄÒ»¸öÖ÷Òª½â¾ö·½°¸£¬ÆäÔ­Àí±È½Ï¼òµ¥£¬ÊµÏÖÒ²±È½Ï·½±ã£¬Ö»ÊÇÓÉÓÚºÍWindowsÖ®¼ä´í×Û¸´ÔӵĹØÏµ£¬µ¼ÖÂÉèÖÃÆðÀ´Óв»ÉÙÀ§ÄÑ£¬³öÏÖÎÊÌâÒ²²»ÈÝÒ×Õï¶Ï¡£
1.ʵÏÖ¸ÅÊö
 *Ë«»úÈȱ¸Õë¶ÔµÄÊǾßÌåµÄij¸öÊý¾Ý¿â¶ø²»ÊÇÕû¸ö·þÎñÆ÷
 Ë«» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ