°²»ÕÊ¡¼ÆËã»ú¶þ¼¶VFP¿¼ÊÔÀíÂÛÄ£ÄâÊÔÌ⣨¸½´ð°¸£©DOC ÏÂÔر¾ÎÄ

PROCEDURE GC PARAMETERS P,W P=W*W RETURN ENDPROC

ËÄ¡¢±à³ÌÌ⣨µÚ1¡¢2Ìâ¸÷6·Ö£¬µÚ3Ìâ8·Ö£¬¹²20·Ö£©

1£®´Ó¼üÅÌÊäÈëÒ»¸öÕûÊýX£¬¼ÆËã²¢Êä³öº¯Êý

?X?5(XΪÆæÊý)?µÄÖµ¡£ Y???X3?25(XΪżÊý)?2£®´Ó¼üÅÌÊäÈëÒ»¸öÕýÕûÊýN£¬¼ÆËã²¢Êä³öS=1+2+ ¡­ +N¡£

3£®ÒÑÖªÊý¾Ý±íXSCJ.DBFºÍTJ.DBF£¬Æä½á¹¹ºÍÄÚÈÝÈçϱíËùʾ£¬±àд³ÌÐòʵÏÖÈçϹ¦ÄÜ£º

¢ÙÌî³äXSCJ.DBF±íÖеġ°ºÏ³É³É¼¨¡±×ֶΣ¨ºÏ³É³É¼¨=±ÊÊԳɼ¨*60%+»úÊԳɼ¨*40%£©£»

¢ÚXSCJ.DBF±íÖкϳɳɼ¨ÔÚ85·ÖÒÔÉÏ£¨º¬85·Ö£©ÎªÓÅÐã¡¢60·ÖÖÁ85·Ö£¨º¬60·Ö£©ÎªºÏ¸ñ¡¢60·ÖÒÔÏÂΪ²»ºÏ¸ñ£¬¸ù¾Ý±íXSCJ.DBFÖеÄÊý¾Ý·Ö±ðͳ¼Æ¸÷רҵÓÅÐã¡¢ºÏ¸ñºÍ²»ºÏ¸ñÈËÊý²¢Ìî³äµ½±íTJ.DBFµÄÏàÓ¦×Ö¶ÎÖС£

±íXSCJ.DBF

µÚ 13 Ò³ ¹² 18 Ò³

×¼¿¼Ö¤×¨Òµ´úºÅ 2008001 2008002 2008003 2008004 ©¯ ©¯ 2001 ºÅ 1002 £¨C£© £¨C£© ÐÕÃû ±ÊÊԳɻúÊԳɺϳɳɣ¨C£© ÍõÀö ¼¨ 75 88 ¼¨ 84 65 ¼¨ £¨N£© £¨N£© £¨N£© 1001 ÂíÇìȪ 1002 Àîɺɺ Àî¸Õ ©¯ 55 98 ©¯ 67 88 ©¯ ±íTJ.DBF

רҵ´úºÅ רҵÃû³Æ ÓÅÐãÈËÊý ºÏ¸ñÈËÊý ²»ºÏ¸ñÈË£¨C£© 1001 1002 2001 ©¯

µÚ 14 Ò³ ¹² 18 Ò³

£¨C£© ¼ÆËã»ú ÍøÂ繤³Ì ÐÅÏ¢¹ÜÀí ©¯ £¨N£© £¨N£© Êý £¨N£©

µÚÒ»Ì×ÀíÂÛÄ£ÄâÌâ²Î¿¼´ð°¸ Ò»¡¢µ¥ÏîÑ¡ÔñÌâ

1. D 2.B 3.B 4.A 5.D 6.C 7.B 8.C 9.A

10.A

11. C 12.C 13.B 14.B 15.B 16.A 17.C 18.D

19.D 20.B

21. B 22.D 23.B 24.C 25.C 26.D 27.A 28.D

29.C 30.A

31. C 32. B 33.A 34.B 35. D 36. C 37.B 38.A 39.D 40. C ¶þ¡¢Ìî¿ÕÌâ 1. ÏîÄ¿¹ÜÀíÆ÷ 2. sqrt(x^2+y)/(2-y) 3. ¡°CDE¡±

4. sele * from dangan where Ö°³Æ=¡±½ÌÊÚ¡± order by ¹¤×Ê desc into; dbf px 5. Ô¶³Ì 6. group by 7. ±í¼Ç¼×ÜÊý

µÚ 15 Ò³ ¹² 18 Ò³

8. ±à¼­ 9. 500 10. \\- Èý¡¢ÔĶÁÀí½âÌâ 1. 10 2.120 3.144

4.ÏÔʾxscj±íÖÐ×î¸ß³É¼¨ 5.149 ËÄ¡¢±à³ÌÌâ 1.ÂÔ 2.ÂÔ 3.(1) USE XSCJ

REPLACE ALL ºÏ³É³É¼¨ WITH ±ÊÊԳɼ¨*0.6+»úÊԳɼ¨*0.4 (2)

SET TALK OFF SELE 1 USE XSCJ SELE 2 USE TJ

µÚ 16 Ò³ ¹² 18 Ò³