ÇóSQLÓï¾ä

ÏÖÓÐÈçÏÂÊý¾Ý±íºÍÊý¾Ý£¬ÇëÎÊÔõÑùʵÏÖÎÒÐèÒªµÄ²éѯÓï¾ä£¨ÒªÇóÔÚ×îºóÃæµÄ×¢ÊÍÖУ©

--Êý¾Ý¿âΪSQL Sever 2005,½¨Á¢µÄÊý¾Ý¿âÃû³ÆΪDatabaseStudy
Use DatabaseStudy;
--¹©Ó¦ÉÌ±í£¨´úÂ룬ÐÕÃû£¬×´Ì¬£¬ËùÔÚ³ÇÊУ©
Create Table S( FSNO char(4) Primary Key,
FSNAME char(10),
FSTATUS int,
FCITY char(10));
--Áã¼þ±í£¨´úÂ룬Ãû³Æ£¬ÑÕÉ«£¬ÖØÁ¿£©
Create Table P( FPNO char(4) Primary Key,
FPNAME char(10),
FCOLOR char(4),
FWEIGHT char(10));
--¹¤³ÌÏîÄ¿±í£¨´úÂ룬Ãû³Æ£¬ËùÔÚ³ÇÊУ©
Create Table J( FJNO char(4) Primary Key,
FJNAME char(10),
FCITY char(10));
--¹©Ó¦Çé¿ö±í£¨¹©Ó¦ÉÌ´úÂ룬Áã¼þ´úÂ룬¹¤³ÌÏîÄ¿´úÂ룬¹©Ó¦ÊýÁ¿£©
Create Table SPJ( FSNO char(4) Foreign Key References S(FSNO),
FPNO char(4) Foreign Key References P(FPNO),
FJNO char(4) Foreign Key References J(FJNO),
FQTY int,
Primary Key(FSNO,FPNO,FJNO));

--²åÈëÊý¾Ý
--±íS
Insert Into S Values('S1','¾«Òæ',20,'Ìì½ò');
Insert Into S Values('S2','Ê¢Îý',10,'±±¾©');
Insert Into S Values('S3','¶«·½ºì',30,'±±¾©');
Insert Into S Values('S4','·áÌ©Ê¢',20,'Ìì½ò');
Insert Into S Values('S5','ΪÃñ',30,'ÉϺ£');

--±íP
Insert Into P Values('P1','ÂÝĸ','ºì&#