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

1433¶Ë¿ÚÓ³Éä ¼ÜÉèsql server
¡¾×ª¡¿ http://blog.csdn.net/lee576/archive/2007/11/12/1880001.aspx
¹ØÓÚͨ¹ýÍâÍøÁ¬½ÓÄÚÍøSQL Server·þÎñÆ÷µÄ·½·¨
      ½üÈÕ£¬ÔÚÂÛ̳ÉÏ¿´µ½µÄÓйØSQL ServerÔ¶³ÌÁ¬½ÓµÄÎÄÕºó£¬ÕæµÄÊÜÒæÁ¼¶à¡£Ò»Ö±ÒÔÀ´À§»óÁËÒѾõĹØÓÚ´ÓÍâÍøÈçºÎÁ¬½Óµ½ÄÚÍøµÄSQL Server·þÎñÆ ......

SQL SERVER ²éѯÓï¾äÓÅ»¯(ת)

1¡¢  ÓóÌÐòÖУ¬±£Ö¤ÔÚʵÏÖ¹¦ÄܵĻù´¡ÉÏ£¬¾¡Á¿¼õÉÙ¶ÔÊý¾Ý¿âµÄ·ÃÎÊ´ÎÊý£»Í¨¹ýËÑË÷²ÎÊý£¬¾¡Á¿¼õÉÙ¶Ô±íµÄ·ÃÎÊÐÐÊý,×îС»¯½á¹û¼¯£¬´Ó¶ø¼õÇáÍøÂ縺µ££»Äܹ»·Ö¿ªµÄ ²Ù×÷¾¡Á¿·Ö¿ª´¦Àí£¬Ìá¸ßÿ´ÎµÄÏìÓ¦Ëٶȣ»ÔÚÊý¾Ý´°¿ÚʹÓÃSQLʱ£¬¾¡Á¿°ÑʹÓõÄË÷Òý·ÅÔÚÑ¡ÔñµÄÊ×ÁУ»Ëã·¨µÄ½á¹¹¾¡Á¿¼òµ¥£»ÔÚ²éѯʱ£¬²»Òª¹ý¶àµØʹÓÃͨÅä·û ÈçSELE ......

SQL 2005 ´´½¨Ô¼Êø

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

SQL WHERE 1=1

1=1»òÕß'a'='a'µÈµÈºãµÈʽÊÇT-SQLÖбí´ïtrueµÄ·½·¨¡£ÒòΪÔÚT-SQLÖÐûÓÐtrueÕâÑùµÄ¹Ø¼ü
×Ö»òÖµ£¬ËùÒÔÐèÒª½èÖúÕâЩºãµÈʽÀ´±í´ïtrueµÄ¸ÅÄî¡£
Ïà¶ÔµÄ£¬Í¬Ñù¿ÉÒÔʹÓÃ1<>1»òÕß1=2µÈÀ´±í´ïfalse¡£
ÔÚÓ¦ÓóÌʽµÄ°²È«ÐÔ·½Ã棬ʹÓÃÕâЩʽ×ÓÊÇSQL×¢ÈëµÄ»ù±¾Ô­Àí£¬ËùÒÔÔÚÆ´½ÓSQLÓï¾äµÄʱºòÒª¹ýÂ˸÷ÖÖ¸÷ÑùµÄÃô¸Ð×Ö
·û¡£
µ±È» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ