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
Ïà¹ØÎĵµ£º
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 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 ......
pl/sql ÌṩÁËÇ¿´ó¶øÁé»îµÄÊÖ¶ÎÀ´²¶×½ºÍ´¦Àí³ÌÐò²úÉúµÄÒì³££¬´Ó¶øÊ¹ oracle µÄÓû§Ô¶ÀëһЩÁîÈË·³ÄÕµÄ bug ¡£
pl/sql Òì³£´¦ÀíµÄ¸ÅÄîºÍÊõÓï
ÔÚ oracle ÖÐËùÓеĴíÎó¶¼±»ÈÏΪÊDz»Ó¦¸Ã·¢ÉúµÄÒì³£¡£Ò»¸öÒì³£¿ÉÄÜÊÇÒÔÏ 3 ÖÖÇé¿öµÄÒ»ÖÖ£º
u ÓÉϵͳ²úÉúµÄ´íÎó£¨& ......
Áª½ÓÌõ¼þ¿ÉÔÚ from »ò WHERE ×Ó¾äÖÐÖ¸¶¨£¬½¨ÒéÔÚ from ×Ó¾äÖÐÖ¸¶¨Áª½ÓÌõ¼þ¡£WHERE ºÍ HAVING ×Ó¾äÒ²¿ÉÒÔ°üº¬ËÑË÷Ìõ¼þ£¬ÒÔ½øÒ»²½É¸Ñ¡Áª½ÓÌõ¼þËùÑ¡µÄÐС£
Áª½Ó¿É·ÖΪÒÔϼ¸Àࣺ   ......
ÈÕÖ¾´«ËÍÊÇSQL SERVER2000ÆóÒµ°æ½øÐÐË«»úÈȱ¸µÄÒ»¸öÖ÷Òª½â¾ö·½°¸£¬ÆäÔÀí±È½Ï¼òµ¥£¬ÊµÏÖÒ²±È½Ï·½±ã£¬Ö»ÊÇÓÉÓÚºÍWindowsÖ®¼ä´í×Û¸´ÔӵĹØÏµ£¬µ¼ÖÂÉèÖÃÆðÀ´Óв»ÉÙÀ§ÄÑ£¬³öÏÖÎÊÌâÒ²²»ÈÝÒ×Õï¶Ï¡£
1.ʵÏÖ¸ÅÊö
*Ë«»úÈȱ¸Õë¶ÔµÄÊǾßÌåµÄij¸öÊý¾Ý¿â¶ø²»ÊÇÕû¸ö·þÎñÆ÷
Ë«» ......