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

Microsoft SQL Server 2008°²×°Í¼½â(Windows 7)

Microsoft SQL Server 2008
°²×°Í¼½â(Windows 7)
FoxDie
2010Äê04ÔÂ17ÈÕ
¼ò½é
±¾ÎÄÏêϸ¼Ç¼ÁËÒ»´ÎÍêÕûµÄMicrosoft SQL Server 2008ÔÚWindows 7²Ù×÷ϵͳÉϵݲװ¹ý³Ì¡£×¢Ò⣺Microsoft SQL Server 2008ÓëWindows 7²Ù×÷ϵͳ´æÔÚÒ»¶¨µÄ¼æÈÝÐÔÎÊÌ⣬ÔÚÍê³É°²×°Ö®ºóÐèҪΪMicrosoft SQL Server 2008°²×°SP1²¹¶¡¡£ÏÂÃæ½«Ïêϸ˵Ã÷Õû¸ö°²×°¹ý³Ì¡£
°²×°ÈÕÖ¾
    ÔÚWindows7²Ù×÷ϵͳϵ£¬Æô¶¯Microsoft SQL 2008°²×°³ÌÐòºó£¬ÏµÍ³¼æÈÝÐÔÖúÊÖ½«ÌáʾÈí¼þ´æÔÚ¼æÈÝÐÔÎÊÌ⣬ÔÚ°²×°Íê³ÉÖ®ºó±ØÐë°²×°SP1²¹¶¡²ÅÄÜÔËÐУ¬Èçͼ1-1Ëùʾ¡£ÕâÀïÑ¡Ôñ“ÔËÐгÌÐò”¿ªÊ¼SQL Server 2008µÄ°²×°¡£
 
 
ͼ1-1¼æÈÝÐÔÎÊÌâÌáʾ
    ½øÈëSQL Server°²×°ÖÐÐĺóÌø¹ý“¼Æ»®”ÄÚÈÝ£¬Ö±½ÓÑ¡Ôñ½çÃæ×ó²àÁбíÖеē°²×°”£¬Èçͼ1-2Ëùʾ£¬½øÈë°²×°ÁбíÑ¡Ôñ¡£
 
ͼ1-2SQL Server°²×°ÖÐÐÄ-¼Æ»®
    Èçͼ1-3Ëùʾ£¬½øÈëSQL Server°²×°ÖÐÐÄ-°²×°½çÃæºó£¬ÓÒ²àµÄÁбíÏÔʾÁ˲»Í¬µÄ°²×°Ñ¡Ïî¡£±¾ÎÄÒÔȫа²×°ÎªÀý˵Ã÷Õû¸ö°²×°¹ý³Ì£¬Òò´ËÕâÀïÑ¡ÔñµÚÒ»¸ö°²×°Ñ¡Ïî“È«ÐÂSQL Server¶ÀÁ¢°²×°»òÏÖÓа²×°Ìí¼Ó¹¦ÄÜ”¡£
 
ͼ1-3 SQL Server°²×°ÖÐÐÄ-°²×°
    Ñ¡Ôñȫа²×°Ö®ºó£¬ÏµÍ³³ÌÐò¼æÈÝÖúÊÖÔÙ´ÎÌáʾ¼æÈÝÐÔÎÊÌ⣬Èçͼ1-4Ëùʾ¡£Ñ¡Ôñ“ÔËÐгÌÐò”¼ÌÐø°²×°¡£
 
ͼ1-4 ¼æÈÝÐÔÎÊÌâÌáʾ
    Ö®ºó½øÈë“°²×°³ÌÐòÖ§³Ö¹æÔò”°²×°½çÃæ£¬°²×°³ÌÐò½«×Ô¶¯¼ì²â°²×°»·¾³»ù±¾Ö§³ÖÇé¿ö£¬ÐèÒª±£Ö¤Í¨¹ýËùÓÐÌõ¼þºó²ÅÄܽøÐÐÏÂÃæµÄ°²×°£¬Èçͼ1-5Ëùʾ¡£µ±Íê³ÉËùÓмì²âºó£¬µã»÷“È·¶¨”½øÐÐÏÂÃæµÄ°²×°¡£
 
ͼ1-5 °²×°³ÌÐòÖ§³Ö¹æÔò
    ½ÓÏÂÀ´ÊÇSQL Server2008°æ±¾Ñ¡ÔñºÍÃÜÔ¿Ìîд£¬±¾ÎÄÒÔ“Enterprise Evaluation”ΪÀý½éÉܰ²×°¹ý³Ì£¬ÃÜÔ¿¿ÉÒÔÏòMicrosoft¹Ù·½¹ºÂò£¬Èçͼ1-6Ëùʾ¡£
 
ͼ1-6 ²úÆ·ÃÜÔ¿
    ÔÚÐí¿ÉÌõ¿î½çÃæÖУ¬ÐèÒª½ÓÊÜMicrosoftÈí¼þÐí¿ÉÌõ¿î²ÅÄܰ²×°SQL Server2008£¬Èçͼ1-7Ëùʾ¡£
 
ͼ1-7 Ðí¿ÉÌõ¿î
    ½ÓÏÂÀ´½«½øÐа²×°Ö§³Ö¼ì²ì£¬Èçͼ1-8Ëùʾ£¬µã»÷“°²×°”¼ÌÐø°²×°¡£
 
ͼ1-8 °²×°³ÌÐòÖ§³ÖÎļþ
    Èçͼ1-9Ëùʾ£¬µ±ËùÓмì²â¶¼Í¨¹ýÖ®ºó²ÅÄܼÌÐøÏÂÃæµÄ°²×°¡£Èç¹û³öÏÖ´íÎó£¬ÐèÒª¸üÕýËùÓÐʧ°Üºó²ÅÄܰ²×°¡£


Ïà¹ØÎĵµ£º

SQLÇó½â°Ë»ÊºóÎÊÌ⣨92ÖÖ½á¹û£©

--¸Ã±í±£´æ½á¹û
create table c(c1 tinyint, c2 tinyint, c3 tinyint, c4 tinyint, c5 tinyint, c6 tinyint, c7 tinyint, c8 tinyint, c9 tinyint, c10 tinyint, c11 tinyint, c12 tinyint, c13 tinyint, c14 tinyint, c15 tinyint, c16 tinyint, c17 tinyint, c18 tinyint, c19 tinyint, c20 tinyint, c21 tinyint, c22 t ......

ÔÚlinuxÉÏÅäÖÃunixODBCºÍFreeTDS·ÃÎÊMS SQL Server


Ò», °²×° unixODBC
ÏÂÔØ°²×°°ü. ÔÚ RedHat °²×°¹âÅÌÉϾÍÓÐ
unixODBC-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm
°²×°
rpm -Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpm
rpm -Uvh unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
Èç¹û°²×°ÖÐÌáʾÓÐ¶ÔÆäË ......

SQL·Ö¸î¶ººÅµÄº¯ÊýºÍÓ÷¨

      ÔÚ³ÌÐòÖÐÎÒÃÇ¿ÉÄܾ­³£»áÓöµ½ÕâÖÖÇé¿ö£¬±ÈÈçҪȡһ¸ölistboxÀïÃæµÄÑ¡ÔñÏµÃµ½µÄ½á¹û¿ÉÄÜÊÇstring ID="id1,id2,id3,id4",È»ºóÎÒÃÇÒª°ÑÕâЩID²åÈëµ½Êý¾Ý¿âÖУ¬Í¬Ê±Ã¿¸öid¶ÔÓ¦µÄÊÇÒª²åÈëÒ»Ìõ¼Ç¼¡£ÊµÏֵķ½·¨Óкܶ࣬µ«ÊÇÈç¹ûÎÒÃÇͨ¹ýÏÂÃæÕâ¸öº¯Êý£¨RecurrentSplit£©¾ÍÄܼòµ¥µÄ´ïµ½ ......

sql¾­µäÓï¾ä

SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ