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

SqlServerÖÐÐбäÁÐ

     ÀýÈç´´½¨Ò»¸ö±í
                 create table stz
              (
             stuNO int  primary key ,
             subject nvarchar(20) not null,
             score int not null
              )
              insert into stz values(1000 ,'Êýѧ',90)
              insert into stz values(1001,'ÓïÎÄ',90)
              insert into stz values(1002,'Ó¢Óï',90)
              insert into stz values(1001 ,'Êýѧ',90)
              insert into stz values(1002,'ÓïÎÄ',90)
              insert into stz values(1000,'Ó¢Óï',90)
              insert into stz values(1002 ,'Êýѧ',90)
              insert into stz values(1000,'ÓïÎÄ',90)
              insert into stz values(1001,'Ó¢Óï',90)
--              ÏÖÔÚµÄÇé¿öÊÇ
            select * from stz;
                    &n


Ïà¹ØÎĵµ£º

SqlServerÃüÃû¹æ·¶

ÃüÃû¹ý³ÌÖÐÈçÓÐÏÖ´æµÄËõд£¬ÔòʹÓøÃËõд£¬ÈçÎÞ£¬Ò»Âɲ»µÃËõд£¬Àý£ºISBN
Êý¾Ý¿â£ºÓÃÒ»¸ö»òÈý¸öÒÔÏÂÓ¢Îĵ¥´Ê×é³É£¬µ¥´ÊÊ××Öĸ´óд£¬È磺DepartmentManage£»
±íÃû£ºÊ¹ÓÃÃû´ÊÐÔÖʵĵ¥´ÊÈ«Æ´±íʾ£¬¸÷µ¥´ÊÊ××Öĸ´óд£¬ ʹÓø´ÊýÐÎʽ£¬È磺Books
      Èç¹û¸Ã±íÓÃÓÚ±íÃ÷ÁíÍâÁ½±íÖÐ×ֶμäµÄ¹Øϵ£¬Óõ ......

SQLServerµÄÁ½¸öά»¤¼¼ÇÉ

¡¡È·Êµ£¬Êý¾Ý¿âµÄά»¤³£³£½»¸øÄÇЩרҵµÄÊý¾Ý¿â¹ÜÀíÔ±£¬µ«ÊÇ×÷Ϊһ¸ö¿ª·¢Õߣ¬ÄãÒ²Ðíż¶ûÐèÒªÔÝʱ´ÓÊÂÕâ¸ö¹¤×÷¡£ËùÒÔ£¬ÊÔÒ»ÊÔÕâÁ½¸öSQL·þÎñÆ÷ά»¤¼¼ÇÉ£ºÇáËɸıäÊý¾Ý¿âÓµÓÐÕß¡¢ÕûÀíË÷ÒýËéƬ¡£Ë­»áÏëµ½ÄãÉõÖÁ¿ÉÒÔ¸øÄÇЩÊý¾Ý¿â¹ÜÀíÔ±½ÌÉÏÒ»Á½¸öм¼ÇÉÄØ£¿ÖØÖ¸¶¨Êý¾Ý¿âÓµÓÐÕßµ±»Ø¸´»òÕßн¨Êý¾Ý¿âʱ£¬ÄãÓÐûÓÐ×¢Òâµ½SQL Server° ......

sqlserver 2000 Ô¶³ÌÁ¬½Ó ·þÎñÆ÷µÄ½â¾ö·½°¸

sqlserver 2000 Ô¶³ÌÁ¬½Ó ·þÎñÆ÷µÄ½â¾ö·½°¸
Ïêϸ³ö´¦²Î¿¼£ºhttp://www.jb51.net/article/18774.htm
¾ßÌå²½Ö裺
Ò»¡¢ping·þÎñÆ÷IPÄÜ·ñpingͨ
¹Û²ìÔ¶³ÌSQL Server 2000·þÎñÆ÷µÄÎïÀíÁ¬½ÓÊÇ·ñ´æÔÚ¡£Èç¹û²»ÐУ¬Çë¼ì²éÍøÂ磬²é¿´ÅäÖ㬵±È»µÃÈ·±£Ô¶³Ìsql server 2000·þÎñÆ÷µÄIPƴдÕýÈ·¡£
¶þ ÔÚDos»òÃüÁîÐÐÏÂÊäÈëtelnet · ......

sqlserver һЩȫ¾Ö±äÁ¿

sqlserver ÖÐ È«¾Ö±äÁ¿ ÊÇÒ»ÖÖÌØÊâÀàÐ͵ıäÁ¿£¬È«¾Ö±äÁ¿ÒÔ@@¿ªÍ·£¬ÊÇÓÉϵͳ¶¨ÒåµÄ¡£
@@CONNECTIONS   ·µ»Ø
SQL Server
×ÔÉÏ´ÎÆô¶¯ÒÔÀ´³¢ÊÔµÄÁ¬½ÓÊý¡£
@@CURSOR_ROWS  
È·¶¨µ±Æä±»µ÷ÓÃʱ¼ìË÷ÁËÓαê·ûºÏÌõ¼þµÄÐÐÊý¡£
@@DATEFIRST       
Õë¶Ô»á»°·µ»Ø
S ......

SQLSERVERÍâÁ¬½Ó·û

±íA
tmpA:
id     name
00     Ãû×ÖA
01     Ãû×ÖB
02     Ãû×ÖC
03     Ãû×ÖD
04     Ãû×ÖE
tmpB:
id     class
02     °à¼¶A
06 & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ