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 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 ......
ORDER BY ÅÅÐò
ASC ÉýÐò(ĬÈÏ)
DESC ½µÐò
select * from s_emp order by dept_id , salary desc
²¿ÃźÅÉýÐò£¬¹¤×ʽµÐò
¹Ø¼ü×ÖdistinctÒ²»á´¥·¢ÅÅÐò²Ù×÷¡£
select * from employee order by 1; //°´µÚÒ»×Ö¶ÎÅÅÐò
NULL±»ÈÏΪÎÞÇî´ó¡£order by ¿ÉÒÔ¸ú±ðÃû¡£
select table_name ......
1. ˵Ã÷£º¸´ÖƱí(Ö»¸´Öƽṹ£¬Ô´±íÃû£ºa£¬Ð±íÃû£ºb)
SQL: select * into b from a where 1<>1;
2. ˵Ã÷£º¿½±´±í(¿½±´Êý¾Ý£¬Ô´±íÃû£ºa£¬Ä¿±ê±íÃû£ºb)
SQL: insert into b(a, b, c) select d, e, f from b;
&nb ......
ÈÕÖ¾´«ËÍÊÇSQL SERVER2000ÆóÒµ°æ½øÐÐË«»úÈȱ¸µÄÒ»¸öÖ÷Òª½â¾ö·½°¸£¬ÆäÔÀí±È½Ï¼òµ¥£¬ÊµÏÖÒ²±È½Ï·½±ã£¬Ö»ÊÇÓÉÓÚºÍWindowsÖ®¼ä´í×Û¸´ÔӵĹØϵ£¬µ¼ÖÂÉèÖÃÆðÀ´Óв»ÉÙÀ§ÄÑ£¬³öÏÖÎÊÌâÒ²²»ÈÝÒ×Õï¶Ï¡£
1.ʵÏÖ¸ÅÊö
*Ë«»úÈȱ¸Õë¶ÔµÄÊǾßÌåµÄij¸öÊý¾Ý¿â¶ø²»ÊÇÕû¸ö·þÎñÆ÷
Ë«» ......