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 ......
1¡¢²éÕÒ±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö× ......
ÐÔÄܼà¿ØÖ®¼à¿ØSQLÓï¾ä
·ÖÎö±í
analyze table tablename compute statistics for all indexes;
analyze table tablename compute statistics for all indexed columns;
analyze table tablename compute statistics for table;
¼à¿ØÊÂÀýµÄµÈ´ý
select event,sum(decode(wait_Tim ......
SELECT
(case when a.colorder=1 then d.name
--+'('+cast(h.value as nvarchar)+')'
else '' end)±íÃû,
a.colorder ×Ö¶ÎÐòºÅ,
a.name ×Ö¶ÎÃû,
isnull(g.[value],'') AS ×Ö¶Î˵Ã÷,
(case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '¡Ì'else '' end) ±êʶ,
(case whe ......
Çé¿ö£ºÎÒÒÔÇ°°²×°¹ýSQL Server 2000£¬Å¶£¬»¹ÓÐSQL Server 2005¡¢MySQLÄØ£¬ºóÀ´ÏµÍ³ÖØ×°ÁË£¬²»¹ýÕâЩӦÓóÌÐò¶¼ÔÚEÅÌÀ²»ÔÚϵͳÅÌÀ¾ÍÔÚ°²×°µÄʱºò³öÏÖÈçÏÂÈý¸ö´íÎó£¬ÔÚ´ËÖð¸ö½â¾ö˵Ã÷ÈçÏ£º
ÎÊÌâÒ»£º
±¨´íÐÅÏ¢£ºÒÔÇ°µÄij¸ö³ÌÐò°²×°ÒÑÔÚ°²×°¼ÆËã»úÉÏ´´½¨¹ÒÆðµÄÎļþ²Ù×÷¡£ÔËÐа²×°³ÌÐò֮ǰ±ØÐëÖØÐÂÆô¶¯¼ÆËã»ú¡£
½â¾ö·½ ......