SQL Server Mobile ѧϰ(Ò»):»·¾³´î½¨
1.SQL Server Mobile ¼ò½é
2.»ñÈ¡ SQL Server Mobile
3.°²×°±Ø±¸Èí¼þ
4.°²×°¿ª·¢»·¾³
5.°²×°·þÎñÆ÷»·¾³
6.ÅäÖà Web ͬ²½Ïòµ¼
7.ʹÓà Internet Explorer ¼ì²é SQL Server Mobile ·þÎñÆ÷´úÀíÅäÖÃ
8.ʹÓÃSQL Server Mobile Êý¾Ý¿â
==========================
1.SQL Server Mobile ¼ò½é
------------------------------
SQL Server Mobile ÊÇÒ»ÖÖ
רΪ¿ª·¢»ùÓÚ Microsoft Windows Mobile µÄÉ豸µÄ¿ª·¢ÈËÔ±
¶øÌṩµÄÒƶ¯Êý¾Ý¿âƽ̨¡£
Microsoft SQL Server 2005 Mobile Edition (SQL Server Mobile)
£¨ÒÔÇ°³ÆΪ Microsoft SQL Server 2000 Windows CE Edition 2.0 (SQL Server CE)£©
½« Microsoft ÆóÒµ½â¾ö·½°¸À©Õ¹µ½É豸ÉϵÄÐÐÒµºÍ¸öÈËÐÅÏ¢¹ÜÀí (PIM) Ó¦ÓóÌÐò£¬
Ϊ¿ª·¢ÈËÔ±½øÐпìËÙÓ¦ÓóÌÐò¿ª·¢ÌṩÁËÒ»Öµıà³ÌÄ£ÐÍ¡£
SQL Server Mobile ÒÔºÜСµÄÄڴ濪ÏúÌṩÁËËùÐèµÄ¹ØϵÊý¾Ý¿â¹¦ÄÜ£º
¿É¿¿µÄÊý¾Ý´æ´¢¡¢ÓÅ»¯²éѯ´¦ÀíÆ÷£¬ÒÔ¼°¿É¿¿¡¢¿ÉÉìËõµÄÁ¬½Ó¹¦ÄÜ¡£
ͨ³££¬Microsoft SQL Server 2005 Mobile Edition (SQL Server Mobile)
×÷ΪӦÓóÌÐòµÄÒ»²¿·ÖÓ¦Óá£
ÔÚÕâÖÖÓ¦ÓóÌÐòÖУ¬
Êý¾ÝÊÇÔŲ́ʽ»úÉ쵀 Microsoft SQL Server ºÍÖ§³ÖµÄÉ豸É쵀 SQL Server Mobile Ö®¼ä½øÐзַ¢µÄ¡£
µ«ÊÇ£¬SQL Server Mobile Ò²¿ÉÒÔÓÃ×÷¸öÈËÐÅÏ¢¹ÜÀí (PIM) ¹¤¾ß»òÕß
ËùÖ§³ÖÉ豸ÉϵÄÆäËûÓ¦ÓóÌÐòµÄ¶ÀÁ¢Êý¾Ý¿â¡£
2.»ñÈ¡ SQL Server Mobile
----------------------------
»ñÈ¡ SQL Server Mobile µÄ·½Ê½ÓÐÒÔÏÂÈýÖÖ£º
(1).¼¯³Éµ½ SQL Server 2005 ÖС£
C:\Program Files\Microsoft SQL Server
\90\Tools\Binn\VSShell\Common7\IDE\sqlce30setupen.msi
(2).¼¯³Éµ½ Microsoft Visual Studio 2005 ÖС£
C:\Program Files\Microsoft Visual Studio 8
\SmartDevices\SDK\SQL Server\Mobile\v3.0\Sqlce30setupcn.msi
(3).´Ó Microsoft ÍøÕ¾½øÐÐÏÂÔØ¡£
ÓйشÓÍøÕ¾ÏÂÔØ SQL Server Mobile µÄÏêϸÐÅÏ¢£¬
Çë²ÎÔÄ Microsoft SQL Server 2005 Mobile Edition Home
Microsoft SQL Server 2005 Mobile Edition Ö÷Ò³¡£
3.°²×°±Ø±¸Èí¼þ
------------------------------
ÔÚ°²×° Microsoft SQL Server 2005 Mobile Edition
Ïà¹ØÎĵµ£º
¿ª·¢»·¾³£º
windows2003£¬°²×°ÁËvs2008¡¢SQL Server2005£¬ÕâÊÇ»ù´¡£¨µ±È»ÓÃvs2003£¬vs2005£¬SQL Server2000ɶµÄÒ²¿ÉÒÔ£¬²»¹ýеÄ×ÜÊǹ¦ÄÜÇ¿´óЩô£¬ºÇºÇ£©£»
ÒòΪ¿ª·¢Ê±¾ø´ó²¿·Öʱ¼äÊÇÔÚÄ£ÄâÆ÷Éϵ÷ÊÔ£¬¶ø²»ÊÇPPC£¬ËùÒÔÄ£ÄâÆ÷ÊDZØÐë°²×°µÄ¡£Õë¶ÔÄãµÄPPC²Ù×÷ϵͳѡÔñ¶ÔÓ¦µÄÄ£ÄâÆ÷Óësdk°ü£¬ÎÒ°²×°µÄÊÇWM6ÖÐÎÄ°æµÄ¡££¨windows ......
¹ØÓÚͨ¹ýÍâÍøÁ¬½ÓÄÚÍøSQL Server·þÎñÆ÷µÄ·½·¨
½üÈÕ£¬ÔÚÂÛ̳ÉÏ¿´µ½µÄÓйØSQL ServerÔ¶³ÌÁ¬½ÓµÄÎÄÕºó£¬ÕæµÄÊÜÒæÁ¼¶à¡£Ò»Ö±ÒÔÀ´À§»óÁËÒѾõĹØÓÚ´ÓÍâÍøÈçºÎÁ¬½Óµ½ÄÚÍøµÄSQL Server·þÎñÆ÷Éϵķ½·¨£¬ÏÖÒѽâ¾öÁË£¬ÏàÐÅÒ²Óв»ÉÙÏóÎÒÕâÑùµÄºüÓÑÃÇ¡£¹Ê´Ë£¬ÏÖÔÚ°ÑÎÒʵÏֵķ½·¨Ä ......
¡¡¡¡ÔÚÊý¾Ý¿âµÄ¿ª·¢¹ý³ÌÖУ¬¾³£»áÓöµ½¸´ÔÓµÄÒµÎñÂß¼ºÍ¶ÔÊý¾Ý¿âµÄ²Ù×÷£¬Õâ¸öʱºò¾Í»áÓÃSPÀ´·â×°Êý¾Ý¿â²Ù×÷¡£Èç¹ûÏîÄ¿µÄSP½Ï¶à£¬ÊéдÓÖûÓÐÒ»¶¨µÄ¹æ·¶£¬½«»áÓ°ÏìÒÔºóµÄϵͳά»¤À§ÄѺʹóSPÂß¼µÄÄÑÒÔÀí½â£¬ÁíÍâÈç¹ûÊý¾Ý¿âµÄÊý¾ÝÁ¿´ó»òÕßÏîÄ¿¶ÔSPµÄÐÔÄÜÒªÇóºÜ£¬¾Í»áÓöµ½ÓÅ»¯µÄÎÊÌ⣬·ñÔòËÙ¶ÈÓпÉÄܺÜÂý£¬¾¹ýÇ×Éí¾Ñ飬һ¸ö¾ ......
SQLÓï¾äÖеÄHaving×Ó¾äÓëwhere×Ó¾äÖ®Çø±ð
---WHERE¾ä×Ó×÷ÓÃÓÚ»ù±¾±í»òÊÔͼ£¬´ÓÖÐÑ¡ÔñÂú×ãÌõ¼þµÄÔª×é¡£HAVING×÷ÓÃÓÚ×飬´ÓÖÐÑ¡ÔñÂú×ãÌõ¼þµÄ×é---
ÔÚ˵Çø±ð֮ǰ£¬µÃÏȽéÉÜGROUP BYÕâ¸ö×Ӿ䣬¶øÔÚ˵GROUP×Ó¾äÇ°£¬ÓÖµÃÏÈ˵˵“¾ÛºÏº¯Êý”——SQLÓïÑÔÖÐÒ»ÖÖÌØÊâµÄº¯Êý¡£ÀýÈçSUM, COUNT, MAX, AVGµÈ¡£Õâ ......
SET TIMING ON | OFF
SQL> set timing on
SQL> select * from emp where empno = 7369;
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- ----------- ---------- ----------
DEPTNO
----------
7369 SMITH CLERK ......