Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

1433¶Ë¿ÚÓ³Éä ¼ÜÉèsql server

¹ØÓÚͨ¹ýÍâÍøÁ¬½ÓÄÚÍøSQL Server·þÎñÆ÷µÄ·½·¨
      ½üÈÕ£¬ÔÚÂÛ̳ÉÏ¿´µ½µÄÓйØSQL ServerÔ¶³ÌÁ¬½ÓµÄÎÄÕºó£¬ÕæµÄÊÜÒæÁ¼¶à¡£Ò»Ö±ÒÔÀ´À§»óÁËÒѾõĹØÓÚ´ÓÍâÍøÈçºÎÁ¬½Óµ½ÄÚÍøµÄSQL Server·þÎñÆ÷Éϵķ½·¨£¬ÏÖÒѽâ¾öÁË£¬ÏàÐÅÒ²Óв»ÉÙÏóÎÒÕâÑùµÄºüÓÑÃÇ¡£¹Ê´Ë£¬ÏÖÔÚ°ÑÎÒʵÏֵķ½·¨Ä ......

SQL 2005 ´´½¨Ô¼Êø

²Î¼û¡¶SQL Sever 2005 Êý¾Ý¿â»ù´¡¼°Ó¦Óü¼Êõ½Ì³ÌÓëʵѵ¡· ÖÜÆæ
 
SQL ServerÖÐÓÐÎåÖÖÔ¼ÊøÀàÐÍ£¬·Ö±ðÊÇCHECKÔ¼Êø¡¢DEFAULTÔ¼Êø¡¢PRIMARY KEYÔ¼Êø¡¢FOREIGN KEYÔ¼ÊøºÍUNIQUEÔ¼Êø¡£
 
1.       CHECKÔ¼Êø£º
CHECKÔ¼ÊøÓÃÓÚÏÞÖÆÊäÈëÒ»Áлò¶àÁеÄÖµµÄ·¶Î§£¬Í¨¹ýÂß¼­±í´ïʽÀ´ÅжÏÊý¾ ......

SQLÓï¾äÖеÄHaving×Ó¾äÓëwhere×Ó¾äÖ®Çø±ð


SQLÓï¾äÖеÄHaving×Ó¾äÓëwhere×Ó¾äÖ®Çø±ð
---WHERE¾ä×Ó×÷ÓÃÓÚ»ù±¾±í»òÊÔͼ£¬´ÓÖÐÑ¡ÔñÂú×ãÌõ¼þµÄÔª×é¡£HAVING×÷ÓÃÓÚ×飬´ÓÖÐÑ¡ÔñÂú×ãÌõ¼þµÄ×é---
ÔÚ˵Çø±ð֮ǰ£¬µÃÏȽéÉÜGROUP BYÕâ¸ö×Ӿ䣬¶øÔÚ˵GROUP×Ó¾äÇ°£¬ÓÖµÃÏÈ˵˵“¾ÛºÏº¯Êý”——SQLÓïÑÔÖÐÒ»ÖÖÌØÊâµÄº¯Êý¡£ÀýÈçSUM, COUNT, MAX, AVGµÈ¡£Õâ ......

SQLÓï¾äÓÅ»¯

SQLÓï¾äµÄÓÅ»¯¾ÍÊǽ«ÐÔÄܽϵ͵ÄSQLÓï¾äת»»´ï³ÉͬÑùÄ¿µÄÐÔÄÜÓÅÒìµÄSQLÓï¾ä
ÏÂÃæÎÒÃÇÒ»ÆðÀ´¿´¿´Ò»Ð©¿ÉÒÔÓÅ»¯SQLµÄ·½·¨£¬Ï£Íû´ó¼Ò¶àÌá³öÒâ¼ûÎÒÃǹ²Í¬Ñ§Ï°»òÕßÊÇ´ó¼ÒÓÐʲôºÃµÄÓÅ»¯·½·¨¿ÉÒÔÌá³öÀ´¹²Ïíһϡ£
 
µÚÒ»ÖÖÓÅ»¯£¨Ê¹ÓÃÖ¸¶¨ÁдúÌæ”*”£©
       ʹÓÓ*&rdquo ......

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ