Êý¾Ý¿âÓëÓ¦ÓÃ

ÄúµÄÐÕÃû:

ÄúµÄÖ÷Ò³µÄÍøÖ·:
ÃÜÂë:

Banana

Apple

Orange

b.asp

´¦ÀíÍøÒ³

<% ¡®aspÓï¾äµÄ±êÖ¾

response.write request(\ÍøÖ·\¡®Êä³öÓû§ÊäÈëµÄÍøÖ·

response.write \¡®»»ÐÐ response.write request(\ÐÕÃû\¡®Êä³öÓû§ÊäÈëµÄÍøÖ·

response.write \¡®»»ÐÐ response.write request(\ÃÜÂë\¡®Êä³öÓû§ÊäÈëµÄÃÜÂë

response.write request(\Ë®¹û\

¡®Êä³öÓû§Ñ¡ÔñµÄË®¹ûÃû³Æ£¬»òÐíµ¥¸ö£¬»òÐíÊǼ¯ºÏ %>

(Selectable Menu)

˵Ã÷£º1.

2.

2009ѧÄêµÚһѧÆÚ¸÷°à¼¶µÄƽ¾ù³É¼¨

µÚÒ»ÖÖ·½·¨£ºÁÐ×ãÌõ¼þ£¬ÔÙ·Ö×é¡£

µÚ 37 Ò³£¨¶þ£©ÏÂÀ­¿ò¡¾Àý¡¿

¡¾×÷Òµ¡¿Í³¼Æ

1.¸ù¾ÝÐèÒª£¬°ÑËùÓÐÐèÒªµÄ×Ö¶Îͨ¹ýÌí¼Ó±íºÍÁ¬½Ó¹«¹²×ֶεķ½Ê½ÁÐÈ«£¬ÔÙ·Ö×éͳ¼ÆÈËÊý£¬ÈçÏȰÑѧԺ¡¢×¨Òµ¡¢Äê¼¶¡¢°à¼¶Ãû³Æ£¬ÒÔ¼°³É¼¨ÁгöÀ´£¬ÈçÏ£º

SELECT c.²¿ÃÅÃû³Æ, d.רҵÃû³Æ, b.Grade, b.°à¼¶Ãû³Æ, f.³É¼¨ FROM ³É¼¨±í f INNER JOIN ѧÉúÐÅÏ¢±í a INNER JOIN

°à¼¶ÐÅÏ¢±í b ON a.°à¼¶±àºÅ = b.°à¼¶±àºÅ INNER JOIN ²¿ÃÅÃû³Æ´úÂë±í c ON b.ѧԺ = c.²¿ÃÅ´úÂë INNER JOIN

רҵÐÅÏ¢±í d ON b.רҵ = d.רҵ´úÂë ON f.ѧºÅ = a.ѧºÅ INNER JOIN ¿Î³ÌÐÅÏ¢±í e ON f.¿Î³Ì±àºÅ = e.¿Î³Ì±àºÅ WHERE (e.ѧÄê = N'2009') AND (e.ѧÆÚ = N'µÚһѧÆÚ')

2. ÔÙ°´ÕÕ·Ö×éÌõ¼þ£¬°Ñgroup by ·Ö×éÌõ¼þ×Ö¶ÎÕ³ÌùÏÂÀ´£¬²¢¶ÔѧºÅ×ֶνøÐÐÊýĿͳ¼Æ¡£¼´³É¼¨Ç°ÃæµÄ×ֶζ¼ÊÇ·Ö×éÌõ¼þ¡£

SELECT c.²¿ÃÅÃû³Æ, d .רҵÃû³Æ, b.Grade, b.°à¼¶Ãû³Æ, AVG(f.³É¼¨) AS ƽ¾ù³É¼¨ FROM ³É¼¨±í f INNER JOIN ѧÉúÐÅÏ¢±í a INNER JOIN

°à¼¶ÐÅÏ¢±í b ON a.°à¼¶±àºÅ = b.°à¼¶±àºÅ INNER JOIN ²¿ÃÅÃû³Æ´úÂë±í c ON b.ѧԺ = c.²¿ÃÅ´úÂë INNER JOIN

רҵÐÅÏ¢±í d ON b.רҵ = d .רҵ´úÂë ON f.ѧºÅ = a.ѧºÅ INNER JOIN ¿Î³ÌÐÅÏ¢±í e ON f.¿Î³Ì±àºÅ = e.¿Î³Ì±àºÅ WHERE (e.ѧÄê = N'2009') AND (e.ѧÆÚ = N'µÚһѧÆÚ') GROUP BY c.²¿ÃÅÃû³Æ, d .רҵÃû³Æ, b.Grade, b.°à¼¶Ãû³Æ

µÚ¶þÖÖ·½·¨£ºÏÈÇó×ÜÆ½¾ù³É¼¨£¬ÔÙÖð²½ÓÉСµ¥Î»µ½´óµ¥Î»¼Ó·Ö¸î¼´·Ö×éÌõ¼þ£¨ÂÔ£© µÚ¾Å½ÌѧÖÜÍê µÚÊ®Öܶ¼¸´Ï°ÁËÉÏÃæÄÚÈÝ

¢ß¸´Ï°¢à

µÚÈý½Ú Êý¾ÝµÄ²åÈ롢ɾ³ýºÍ¸üÐÂ

Ò»¡¢ Êý¾Ý²åÈ룺ʹÓÃINSERTÓï¾äÏò±íÖвåÈëÊý¾Ý£¬¾ä·¨¸ñʽÈçÏ£º

INSERT INTO ±íÃû|ÊÓͼÃû [(×Ö¶ÎÁбí)]

{ VALUES ({DEFAULT | NULL |expression} [,?n]) /*Ö¸¶¨ÁÐÖµµÄ×Ó¾ä*/ | exectute_statement

/*ÓÐЧµÄEXECTUTEÓï¾ä*/

}| DEFAULT VALUES /*ËùÓÐÁоùȡĬÈÏÖµ*/

VALUES×Ó¾äÖеÄÖµ¿ÉÓÐÈýÖÖ£º

(1) DEFAULT£ºÖ¸¶¨Îª¸ÃÁеÄĬÈÏÖµ¡£ÕâÒªÇó¶¨Òå±íʱ±ØÐëÖ¸¶¨¸ÃÁеÄĬÈÏÖµ¡£ (2) NULL£ºÖ¸¶¨¸ÃÁÐΪ¿ÕÖµ¡£

µÚ 38 Ò³

(3) expression£º¿ÉÒÔÊÇÒ»¸ö³£Á¿¡¢±äÁ¿»òÒ»¸ö±í´ïʽ£¬ÆäÖµµÄÊý¾ÝÀàÐÍÒªÓëÁеÄÊý¾ÝÀàÐÍÒ»Ö¡£×¢Òâ±í´ïʽÖв»ÄÜÓÐSELECT¼°EXECUTEÓï¾ä¡£ ͨ¹ýʵÀý¾ßÌå˵Ã÷ÓÐÈçÏÂÈýÖÖ·½·¨£º ¡¾Àý¡¿±¸·Ý¾­¼ÃѧԺµÄ¿Î³ÌÐÅÏ¢µ½a±í SELECT * into a

FROM ¿Î³ÌÐÅÏ¢±í

WHERE (ÊÚ¿ÎѧԺ = N'041')

¡¾Àý¡¿½«ÉúÃüѧԺµÄ¿Î³ÌÐÅÏ¢Ò²±¸·Ýµ½a±í Insert into a SELECT * FROM ¿Î³ÌÐÅÏ¢±í

WHERE (ÊÚ¿ÎѧԺ = N'033')

˵Ã÷£ºÒªÇó²åÈë×ֶκͱ»²åÈë±íµÄ×Ö¶ÎÒ»¶¨ÊÇÊýÄ¿Ïàͬ£¬¶ÔÓ¦ÊôÐÔÒ»Ö²ſÉÒÔ½øÐÐ ¡¾Àý¡¿a±íɾ³ýѧÄꡢѧÆÚÁ½¸ö×ֶΣ¬Ö»Ê£Ï¿γ̱àºÅ, ¿Î³ÌÃû³Æ, ÈονÌʦ, ÊÚ¿ÎѧԺËĸö×ֶΣ¬¼ÌÐø°Ñ·¨Ñ§ÔºµÄ¿Î³ÌÐÅÏ¢±¸·Ýµ½a±í

insert into a( ¿Î³Ì±àºÅ, ¿Î³ÌÃû³Æ, ÈονÌʦ, ÊÚ¿ÎѧԺ)

SELECT ¿Î³Ì±àºÅ, ¿Î³ÌÃû³Æ, ÈονÌʦ, ÊÚ¿ÎѧԺ FROM ¿Î³ÌÐÅÏ¢±í

WHERE (ÊÚ¿ÎѧԺ = N'042')

˵Ã÷£º²åÈë±íºÍ±»²åÈë±íÈç¹û×Ö¶ÎÊýÄ¿²»Í¬¶øÊôÐÔÏàͬ£¬±ØÐëÒª¶ÔÓ¦Áгö×ֶΡ£ ¡¾Àý¡¿Ïòa±íÖвåÈë³£Êý¼Ç¼£¬¶ÔÓ¦×Ö¶ÎÖµ·Ö±ðΪ£º23456£¬Ó¢Ó0123451£¬056 insert into a( ¿Î³Ì±àºÅ, ¿Î³ÌÃû³Æ, ÈονÌʦ, ÊÚ¿ÎѧԺ) values(23456£¬¡¯Ó¢Ó£¬¡¯0123451¡¯£¬¡¯056¡¯) ˵Ã÷£ºÎı¾ÐÍÒª¼Óµ¥ÒýºÅ

¶þ¡¢Êý¾Ýɾ³ý£ºÊ¹ÓÃdelete½«±íÖеÄÊý¾Ý°´Ìõ¼þ´Ó±íÖÐÇå³ý¡£

Óï·¨¸ñʽ£ºDELETE FROM ±íÃû|ÊÓͼ

[WHERE {<Ö¸¶¨Ìõ¼þ>}]

¡¾Àý¡¿½«³É¼¨±íÖÐÑ¡¿Î±àºÅΪ47868,²¢ÇÒѧºÅΪ20093039µÄÊý¾Ýɾ³ý¡£ DELETE FROM³É¼¨±í

WHERE (¿Î³Ì±àºÅ = N'47868') AND (ѧºÅ = N'20093039') ¡¾Àý¡¿½«³É¼¨±íÖгɼ¨Îª¿ÕµÄÐÐɾ³ý¡£ DELETE FROM ³É¼¨±í

µÚ 39 Ò³

WHERE ³É¼¨ IS NULL

¡¾Àý¡¿É¾³ýËùÓÐÐÐ DELETE FROM³É¼¨±í

Èý¡¢¸üÐÂÐÞ¸ÄÊý¾Ý£ºUPDATEÓï¾ä¿ÉÒÔÓÃÀ´Ð޸ıíÖеÄÊý¾ÝÐС£

Óï·¨¸ñʽ: UPDATE ±íÃû|ÊÓͼ

SET {ÁÐÃû={expression|DEFAULT|NULL} /*ΪÁÐÖØÐÂÖ¸¶¨Öµ*/ | @variable = expression | @variable = column = expression }[,?n]

[WHERE <Ö¸¶¨Ìõ¼þ> ]

¡¾Àý¡¿°´ÕÕÌõ¼þ¸üУ¬°ÑѧºÅ = N'20075748'£¬²¢Çҿγ̱àºÅ = N'46607'µÄѧ·Ö¸üгÉ4·Ö¡£

UPDATE [³É¼¨±í] SET ·ÖÊý =4

WHERE (ѧºÅ = N'20075748') AND (¿Î³Ì±àºÅ = N'46607')

µÚËÄ½Ú ÊÓͼµÄ´´½¨¡¢Ð޸ĺÍÓ¦ÓÃ

Ò»¡¢ÊÓͼ£ºÊÇ´ÓÒ»¸ö»ò¶à¸ö±í£¨»òÊÓͼ£©µ¼³öÁÙʱÊý¾ÝµÄ±í¡£

ÊÓͼÊÇÒ»¸öÐé±í£¬¼´ÊÓͼËù¶ÔÓ¦µÄÊý¾Ý²»½øÐÐʵ¼Ê´æ´¢£¬Êý¾Ý¿âÖÐÖ»´æ´¢ÊÓͼµÄ¶¨Ò壬¶ÔÊÓͼµÄÊý¾Ý½øÐвÙ×÷ʱ£¬ÏµÍ³¸ù¾ÝÊÓͼµÄ¶¨ÒåÈ¥²Ù×÷ÓëÊÓͼÏà¹ØÁªµÄ»ù±¾±í¡£ ¶þ¡¢ÊÓͼµÄ´´½¨¡¢Ð޸ĺͱ£´æ£º

1£®Í¨¹ýÃüÁîÖ±½Ó½¨Á¢»òÔÚ²éѯ·ÖÎöÆäÖн¨Á¢ÊÓͼ£º

CREATE VIEW <ÊÓͼÃû> AS <²éѯÓï¾ä> 2£®Í¨¹ý²Ëµ¥²Ù×÷ 3£®Í¨¹ýÏòµ¼

Èý¡¢Í¨¹ýÊÓͼÐÞ¸ÄÊý¾Ý¹æÔò

1£®ÈôÊÓͼÊÇÓɶþ¸öÒÔÉÏ»ù±¾±íµ¼³öµÄ£¬Ôò´ËÊÓͼ²»ÔÊÐí¸üУ»

2£®ÈôÊÓͼµÄ×Ö¶ÎÀ´×Ô±í´ïʽ»ò³£Êý£¬Ôò²»ÔÊÐíÖ´ÐÐINSERTºÍUPDATE²Ù×÷£¬µ«ÔÊÐíDELETE²Ù×÷£»

3£®ÈôÊÓͼ¶¨ÒåÖк¬ÓÐGROUP BY×Ӿ䣬Ôò²»ÔÊÐí¸üУ» 4£®ÈôÊÓͼÖк¬ÓÐDISTINCT¶ÌÓÔò²»ÔÊÐí¸üУ»

5£®ÈôÊÓͼ¶¨ÒåÖÐÓÐǶÌײéѯ£¬²¢ÇÒÄÚ²ã²éѯFROM×Ó¾äÖÐÉæ¼°µ½µÄ±íÒ²Êǵ¼³ö¸ÃÊÓͼµÄ

µÚ 40 Ò³

/*Ö¸¶¨±äÁ¿µÄÐÂÖµ*/

/*Ö¸¶¨ÁкͱäÁ¿µÄÐÂÖµ*/

ÁªÏµ¿Í·þ£º779662525#qq.com(#Ìæ»»Îª@)