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
Ïà¹ØÎĵµ£º
ÃüÃû¹ý³ÌÖÐÈçÓÐÏÖ´æµÄËõд£¬ÔòʹÓøÃËõд£¬ÈçÎÞ£¬Ò»Âɲ»µÃËõд£¬Àý£ºISBN
Êý¾Ý¿â£ºÓÃÒ»¸ö»òÈý¸öÒÔÏÂÓ¢Îĵ¥´Ê×é³É£¬µ¥´ÊÊ××Öĸ´óд£¬È磺DepartmentManage£»
±íÃû£ºÊ¹ÓÃÃû´ÊÐÔÖʵĵ¥´ÊÈ«Æ´±íʾ£¬¸÷µ¥´ÊÊ××Öĸ´óд£¬ ʹÓø´ÊýÐÎʽ£¬È磺Books
Èç¹û¸Ã±íÓÃÓÚ±íÃ÷ÁíÍâÁ½±íÖÐ×ֶμäµÄ¹Øϵ£¬Óõ ......
¡¡È·Êµ£¬Êý¾Ý¿âµÄά»¤³£³£½»¸øÄÇЩרҵµÄÊý¾Ý¿â¹ÜÀíÔ±£¬µ«ÊÇ×÷Ϊһ¸ö¿ª·¢Õߣ¬ÄãÒ²Ðíż¶ûÐèÒªÔÝʱ´ÓÊÂÕâ¸ö¹¤×÷¡£ËùÒÔ£¬ÊÔÒ»ÊÔÕâÁ½¸öSQL·þÎñÆ÷ά»¤¼¼ÇÉ£ºÇáËɸıäÊý¾Ý¿âÓµÓÐÕß¡¢ÕûÀíË÷ÒýËéƬ¡£Ë»áÏëµ½ÄãÉõÖÁ¿ÉÒÔ¸øÄÇЩÊý¾Ý¿â¹ÜÀíÔ±½ÌÉÏÒ»Á½¸öм¼ÇÉÄØ£¿ÖØÖ¸¶¨Êý¾Ý¿âÓµÓÐÕßµ±»Ø¸´»òÕßн¨Êý¾Ý¿âʱ£¬ÄãÓÐûÓÐ×¢Òâµ½SQL Server° ......
sqlserver 2000 Ô¶³ÌÁ¬½Ó ·þÎñÆ÷µÄ½â¾ö·½°¸
Ïêϸ³ö´¦²Î¿¼£ºhttp://www.jb51.net/article/18774.htm
¾ßÌå²½Ö裺
Ò»¡¢ping·þÎñÆ÷IPÄÜ·ñpingͨ
¹Û²ìÔ¶³ÌSQL Server 2000·þÎñÆ÷µÄÎïÀíÁ¬½ÓÊÇ·ñ´æÔÚ¡£Èç¹û²»ÐУ¬Çë¼ì²éÍøÂ磬²é¿´ÅäÖ㬵±È»µÃÈ·±£Ô¶³Ìsql server 2000·þÎñÆ÷µÄIPƴдÕýÈ·¡£
¶þ ÔÚDos»òÃüÁîÐÐÏÂÊäÈëtelnet · ......
sqlserver ÖÐ È«¾Ö±äÁ¿ ÊÇÒ»ÖÖÌØÊâÀàÐ͵ıäÁ¿£¬È«¾Ö±äÁ¿ÒÔ@@¿ªÍ·£¬ÊÇÓÉϵͳ¶¨ÒåµÄ¡£
@@CONNECTIONS ·µ»Ø
SQL Server
×ÔÉÏ´ÎÆô¶¯ÒÔÀ´³¢ÊÔµÄÁ¬½ÓÊý¡£
@@CURSOR_ROWS
È·¶¨µ±Æä±»µ÷ÓÃʱ¼ìË÷ÁËÓαê·ûºÏÌõ¼þµÄÐÐÊý¡£
@@DATEFIRST
Õë¶Ô»á»°·µ»Ø
S ......
±íA
tmpA:
id name
00 Ãû×ÖA
01 Ãû×ÖB
02 Ãû×ÖC
03 Ãû×ÖD
04 Ãû×ÖE
tmpB:
id class
02 °à¼¶A
06 & ......