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

sql ¶à±í¹ØÁª²éѯ

 create database example
use example
create table major
(
 spno varchar(10) primary key not null,
 spname varchar(20) not null
 )
 create table student
(
 sno varchar(10) primary key not null,
 sname varchar(10) not null,
 ssex varchar(2) not null,
 spno varchar(10) foreign key references major(spno)
)
create table course
( cno varchar(10) primary key not null,
  cname varchar(10) not null
 )
create table  scourse
(
 sno varchar(10) foreign key references student(sno),
 cno varchar(10) foreign key references course(cno),
 gmark int
)
insert into major values('001','Ó¢Óï')
insert into major values('002','ÓïÎÄ')
insert into major values('003','Êýѧ')
insert into major values('004','ÉúÎï')
insert into major values('005','ÎïÀí')
insert into major values('006','»¯Ñ§')
insert into student values('2007151301','bobo','ÄÐ','001')
insert into student values('2007151302','roy','ÄÐ','002')
insert into student values('2007151303','max','ÄÐ','004')
insert into student values('2007151304','tony','ÄÐ','004')
insert into student values('2007151305','jaims','ÄÐ','005')
insert into student values('2007151306','wing','ÄÐ','006')
insert into student values('2007151307','allen','ÄÐ','001')
insert into student values('2007151308','heng','ÄÐ','002')
insert into student values('2007151309','chart','ÄÐ','003')
insert into course values('001','ƹÅÒÇò')
insert into course values('002','ÀºÇò')
insert into course values('003','×ãÇò')
insert into course values('004','ÍøÇòÇò')
insert into course values('005','Î赸')
insert into course values('006','è¤Ù¤')
insert into course values('007','ÓÎÓ¾')
insert into scourse values('2007151301','001','88')
insert into scourse values('2007151302','002','88')
insert into scourse values('2007151303','003','88')
insert into scourse values('2007151304','004','88')
insert into scourse values('2007151305','005','88')
insert into scourse val


Ïà¹ØÎĵµ£º

º½¿Õ¹«Ë¾¹ÜÀíϵͳ(VC++ ÓëSQL 2005)

ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
      ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......

SQL Server µ¼³öÊý¾Ý½Å±¾

 1¡£°æ±¾£ºSql2008/2005
 2¡£Ä¿µÄ£ºµ¼³öÖ¸¶¨µÄ±íÖÐËùÓÐÊý¾Ý£¬µ¼³ö¸ñʽΪ insert Óï¾ä
 3¡£¾ßÌå²Ù×÷£º
1£©ÕÒµ½ÐèÒªµ¼³öµÄÊý¾Ý¿â£¬ÓÒ¼ü²Ëµ¥£¬ÈÎÎñ--¡µÉú³É½Å±¾
2£©½øÈëÏòµ¼£¬Ò»Â·ÏÂÒ»²½£¬×¢ÒâÑ¡ÔñÉú³É½Å±¾Ñ¡ÏîµÄʱºò£¬½«“±àдÊý¾ÝµÄ½Å±¾”ÉèÖÃΪ“True”¼´¿É
3£©±£´æÉú³ÉµÄSqlÎļþ ......

SQLÕù°ÔÈüÊÔÌâ¼°²Î¿¼´ð°¸

1.ijҽԺ²¡·¿¼ÆËã»ú¹ÜÀíÖÐÐèÒªÈçÏÂÐÅÏ¢£º£¨15·Ö£©
¿ÆÊÒ£º¿ÆÃû£¬¿ÆµØÖ·£¬¿Æµç»°
²¡·¿£º²¡·¿ºÅ£¬ËùÊô¿ÆÊÒÃû
Ò½Éú£ºÐÕÃû£¬Ö°³Æ£¬ËùÊô¿ÆÊÒÃû£¬ÄêÁ䣬¹¤×÷Ö¤ºÅ
²¡ÈË£º²¡ÀúºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬Õï¶Ï£¬Ö÷¹ÜÒ½Éú£¬²¡·¿ºÅ£¬ÈëסÈÕÆÚ
ÆäÖУ¬Ò»¸ö¿ÆÊÒÓжà¸ö²¡·¿¡¢¶à¸öÒ½Éú£¬Ò»¸ö²¡·¿Ö»ÄÜÊôÓÚÒ»¸ö¿ÆÊÒ£¬Ò»¸öÒ½ÉúÖ»ÊôÓÚÒ»¸ö¿ÆÊÒ£¬µ«¿É¸º ......

SQLµÄǰÊÀ½ñÉú

 Ç°ÑÔÀÎÒ̸µ½ÁËһЩFORTRAN³ÌÐòÔ±ºÍÒ»ÃûLISP³ÌÐòÔ±µÄÊ£¬Ç°ÕßÖ»»áʹÓÃÑ­»·À´½â¾öÎÊÌ⣬ºóÕßÖ»»áʹÓõݹ鷽ʽ½â¾öÎÊÌâ¡£ÕâÖÖÇé¿ö²¢²»
ÉÙ¼û£¬ÒòΪÈËÃǶ¼Ï²»¶Ê¹ÓÃ×Ô¼ºÁ˽âµÄ¹¤¾ß¡£ÏÂÃæ½²Ò»¸öЦ»°£¬²»ÊÇÕæÊ£ºÓÐÈ˸øÒ»¸öÊýѧ¼Ò¡¢Ò»¸öÎïÀíѧ¼ÒºÍÒ»¸öÊý¾Ý¿â³ÌÐòÔ±¸÷·¢ÁËÒ»¸öÏðƤÇò£¬²¢ÇÒÈÃËûÃÇÈ·
¶¨ÇòµÄÌå»ý¡£
Êýѧ¼Ò ......

sql_ÉèÖÃȨÏÞ_Êý¾Ý¿â»ù´¡

ÉèÖÃȨÏÞ
²»ÂÛÓû§»ò½ÇÉ«£¬¶¼ÊÇȨÏÞµÄÉèÖöÔÏó¡£³ýÁËÓ¦ÓóÌÐò½ÇÉ«½ÏÌØÊ⣬ÓëÆäËû½ÇÉ«¼°ÓÃ
»§ÓÐÏ໥ÅÅ³â¹ØÏµÍ⣬Êý¾Ý¿â½ÇÉ«¼°³ÉÔ±ÔÚȨÏ޵ĹØÏµÉϷdz£ÃÜÇС£Ò»¸öÓû§¿ÉÄÜͬʱÁ¥
ÊôÓÚ¶à¸öÊý¾Ý¿â½ÇÉ«£¬Ã¿Ò»½ÇÉ«ÓÖ¿ÉÓµÓв»Í¬È¨ÏÞ£¬´ËʱÓû§»ñȡʵ¼ÊȨÏÞµÄÔ­ÔòÊÇ“²¢
¼¯”£¬³ý·ÇÓÐ deny£¨½ûÖ¹£©µÄÉèÖá£Èç½ÇÉ« A ½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ