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

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


Ïà¹ØÎĵµ£º

Windows Mobile6 Vs2008 Sql Ce3.5 ǶÈëʽӦÓÿª·¢

¿ª·¢»·¾³£º
windows2003£¬°²×°ÁËvs2008¡¢SQL Server2005£¬ÕâÊÇ»ù´¡£¨µ±È»ÓÃvs2003£¬vs2005£¬SQL Server2000ɶµÄÒ²¿ÉÒÔ£¬²»¹ýеÄ×ÜÊǹ¦ÄÜÇ¿´óЩô£¬ºÇºÇ£©£»
ÒòΪ¿ª·¢Ê±¾ø´ó²¿·Öʱ¼äÊÇÔÚÄ£ÄâÆ÷Éϵ÷ÊÔ£¬¶ø²»ÊÇPPC£¬ËùÒÔÄ£ÄâÆ÷ÊDZØÐë°²×°µÄ¡£Õë¶ÔÄãµÄPPC²Ù×÷ϵͳѡÔñ¶ÔÓ¦µÄÄ£ÄâÆ÷Óësdk°ü£¬ÎÒ°²×°µÄÊÇWM6ÖÐÎÄ°æµÄ¡££¨windows ......

SQLÖظ´¼Ç¼²éѯ

1¡¢²éÕÒ±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select   peopleId  from   people  group  by   peopleId  having  count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö× ......

ÐÔÄܼà¿ØÖ®¼à¿ØSQLÓï¾ä

ÐÔÄܼà¿ØÖ®¼à¿Ø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 ......

Sql2005/08 ±í½á¹¹ SQL Óï¾ä

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 2000£¬Å¶£¬»¹ÓÐSQL Server 2005¡¢MySQLÄØ£¬ºóÀ´ÏµÍ³ÖØ×°ÁË£¬²»¹ýÕâЩӦÓóÌÐò¶¼ÔÚEÅÌÀ²»ÔÚϵͳÅÌÀ¾ÍÔÚ°²×°µÄʱºò³öÏÖÈçÏÂÈý¸ö´íÎó£¬ÔÚ´ËÖð¸ö½â¾ö˵Ã÷ÈçÏ£º
ÎÊÌâÒ»£º
±¨´íÐÅÏ¢£ºÒÔÇ°µÄij¸ö³ÌÐò°²×°ÒÑÔÚ°²×°¼ÆËã»úÉÏ´´½¨¹ÒÆðµÄÎļþ²Ù×÷¡£ÔËÐа²×°³ÌÐò֮ǰ±ØÐëÖØÐÂÆô¶¯¼ÆËã»ú¡£
½â¾ö·½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ