VFPϰÌâÒÔ¼°SQLÁ·Ï°Ìâ

49¡¢ÉèÓв¿ÃźÍÖ°Ô±Á½¸öʵÌ壬ÿ¸öÖ°Ô±Ö»ÄÜÊôÓÚÒ»¸ö²¿ÃÅ£¬Ò»¸ö²¿ÃÅ¿ÉÒÔÓжàÃûÖ°Ô±£¬Ôò²¿ÃÅÓëÖ°Ô±Ö®¼äµÄÁªÏµÀàÐÍÊÇ£¨ £©¡£

A¡¢Ò»¶ÔÒ» B¡¢Ò»¶Ô¶à C¡¢¶à¶Ô¶à D¡¢²»È·¶¨ 50¡¢Ö´ÐÐÏÂÁÐÓï¾äºó£¬Ö÷ÆÁÉÏÏÔʾµÄ½á¹ûΪ£¨ £©¡£ DIMENSION m£¨5£© m£¨1£©=5

£¿VARTYPE£¨m£¨5£©£©

A¡¢.T. B¡¢.F. C¡¢5 D¡¢L

51¡¢½¨Á¢Êý¾Ý¿â±íʱ£¬½«¹¤×Ê×Ö¶ÎÖµÏÞÖÆÔÚ1000µ½3000Ö®¼äµÄÕâÖÖÔ¼ÊøÊôÓÚ£¨ £©¡£ A¡¢ÊµÌåÍêÕûÐÔ B¡¢ÓòÍêÕûÐÔ C¡¢²ÎÕÕÍêÕûÐÔ D¡¢ÊÓͼÍêÕûÐÔ 52¡¢Çå³ýÆäÖеڶþ¸ö×Ö·ûΪFµÄÄÇЩÄÚ´æ±äÁ¿µÄÃüÁîÊÇ£¨ £©¡£ A¡¢RELEASE ALL LIKE *F* B¡¢RELEASE ALL LIKE ?F* C¡¢RELEASE ALL EXCEPT ?F* D¡¢RELEASE ALL LIKE ??F* 53¡¢Ö´ÐÐÈçÏÂÃüÁ SET TALK OFF X1=50 Y1='60' Y2='70'

RELEASE ALL EXCEPT Y* LIST MEMORY

µ±ÃüÁîLISTÖ´Ðкó£¬ËùÏÔʾµÄÄÚ´æ±äÁ¿¼°Êý¾ÝÊÇ£¨ £©¡£ A¡¢X1=50¡¢Y1='60'¡¢Y2='70' B¡¢X1=50 C¡¢Y1=60¡¢Y2=70 D¡¢Y1='60'¡¢Y2='70'

54¡¢ÔÚÃüÁî±í´ïÐÎʽÖÐÓÃÓÚÃèÊöij¸öÏîÄ¿ÊDZØÑ¡ÏîµÄ·ûºÅÊÇ£¨ £©¡£ A¡¢[] B¡¢?? C¡¢/ D¡¢¡´ ¡µ

55¡¢Èç¹ûÒ»ÌõÃüÁîÌ«³¤£¬ÔÚÒ»ÐÐÄÚд²»Ï£¬¿ÉÒÔʹÓÃÐøÐзûºÅ£¨ £©¡£ A¡¢£» B¡¢£¬ C¡¢£º D¡¢£¡

56¡¢¹ØÓÚÊéдºÍʹÓÃVFP6.0ÃüÁî²»ÕýÈ·µÄ˵·¨ÊÇ£¨ £©¡£

A¡¢ÃüÁ´Ê¿ÉÒÔдΪǰËĸö×Ö·û B¡¢Ò»ÐÐÄÚÔÊÐíÊéд¶àÌõÃüÁî

C¡¢ÃüÁîÖи÷¶ÌÓï¿É°´ÈÎÒâ˳ÐòÅÅÁУ¬¶ÌÓïµÄÅÅÁÐ˳Ðò²»Ó°ÏìÃüÁîµÄÖ´Ðнá¹ûD¡¢ÃüÁîÖеÄ×Öĸ²»Çø·Ö´óСд£¬Òò´Ë×Öĸ¿ÉÒÔ´óС»ìд

57¡¢Êý¾Ý¹ÜÀí¼¼ÊõËæ×żÆËã»ú¼¼ÊõµÄ·¢Õ¹¶ø·¢Õ¹¡£Êý¾Ý¿â½×¶Î¾ßÓÐÐí¶àÌØµã£¬µ«ÏÂÃæÁгöµÄÌØµãÖУ¨ £©²»ÊÇÊý¾Ý¿â½×¶ÎµÄÌØµã¡£

A¡¢Êý¾Ý½á¹¹»¯ B¡¢Êý¾ÝÃæÏòÓ¦ÓóÌÐò C¡¢Êý¾Ý¹²ÏíÐÔ¸ß D¡¢Êý¾Ý¾ßÓнϸߵĶÀÁ¢ÐÔ ¶þ¡¢ÅжÏÌâ

1¡¢²Ù×÷ϵͳÊÇÊý¾Ý¿âϵͳµÄºËÐIJ¿·Ö¡£ £¨ £© 2¡¢Ä¿Ç°³£ÓõÄÊý¾ÝÄ£ÐÍÖ÷ÒªÓвã´ÎÄ£ÐÍ¡¢Íø×´Ä£Ðͺ͹ØÏµÄ£ÐÍÕâÈýÖÖ¡££¨ £© 3¡¢ÓùØÏµÄ£ÐÍÉè¼ÆµÄÊý¾Ý¿â¾ÍÊǹØÏµÐÍÊý¾Ý¿â¡£ £¨ £© 4¡¢VFP6.0ÊÇÒ»ÖÖÍø×´Ð͵ÄÊý¾Ý¿â¹ÜÀíϵͳ¡£ £¨ £© 5¡¢Í¶Ó°²Ù×÷²»ÄÜ¸Ä±ä¹ØÏµ£¨±í£©µÄ½á¹¹¡£ £¨ £© 6¡¢VFP6.0¹æ¶¨µÄȱʡÇé¿öÏ¿ÉÒÔʹÓõÄÄÚ´æ±äÁ¿Îª256¸ö¡£ £¨ £© 7¡¢Êý×é¿ÉÒÔ²»Ïȶ¨Òå¶øÖ±½ÓʹÓᣠ£¨ £© 8¡¢ÔÚVFP6.0ÖÐ,Êý×Ö×î´óλÊýΪ19λ(°üÀ¨Ð¡Êýµã),ÓÐЧÊý×ÖµÄÊýÖµ¼ÆË㾫¶ÈÒ²ÊÇ19λ¡££¨ £©

9¡¢ÄÚ´æ±äÁ¿µÄÀàÐÍÊÇÓÉÄÚ´æ±äÁ¿Ãû¾ö¶¨µÄ¡£ £¨ £© 10¡¢ÄÚ´æ±äÁ¿ºÍ×ֶαäÁ¿¿ÉʹÓõÄÊý¾ÝÀàÐÍÍêÈ«Ïàͬ¡£ £¨ £© 11¡¢Ò»¸ö×Ö·ûÐͳ£Êý¿ÉÒÔ°üº¬ÈÎÒâ¶à¸ö×Ö·û¡£ £¨ £© 12¡¢µ±Í˳öVFP6.0ϵͳ֮ºó£¬ÄÚ´æÖеıäÁ¿¼°ÆäÊý¾Ý½«È«²¿Ïûʧ¡££¨ £© 13¡¢Ò»¸öÄÚ´æ±äÁ¿µÄÊý¾ÝÀàÐÍÒ»µ©±»È·¶¨ºó£¬²»ÄÜÔٸıäÆäÀàÐÍ¡££¨ £© 14¡¢µ±ÄÚ´æ±äÁ¿Óë×ֶαäÁ¿Í¬Ãû£¬ÏµÍ³ÓÅÏȵذ´ÄÚ´æ±äÁ¿¶Ô´ý¡££¨ £© 15¡¢ÔڱȽÏÁ½¸ö×Ö·û´®µÄ´óСʱ£¬Êµ¼ÊÉÏÊDZȽÏËüÃǰüº¬×Ö·û¸öÊý¶àÉÙ¡££¨ £© 16¡¢Âß¼­ÔËËã·ûµÄÔËËãÓÅÏȼ¶×ÜÊǸßÓÚ¹ØÏµÔËËã·û¡£ £¨ £© 17¡¢Ö´ÐÐSTORE 500 TO A£¬B£¬CÕâÌõÃüÁîºó£¬±äÁ¿BµÄÖµÊÇ500¡££¨ £© Èý¡¢Ìî¿ÕÌâ¡£

1¡¢Êý¾Ý¿âϵͳÊÇÖ¸¼ÆËã»úϵͳÒýÈëÊý¾Ý¿âºóµÄϵͳ¹¹³É,ËüÖ÷Òª°üÀ¨______¡¢_____¡¢_________¡¢___________ºÍ__________µÈ×é³É²¿·Ö¡£

2¡¢Óöþά±íÀ´±íʾʵÌ弰ʵÌåÖ®¼äÁªÏµµÄÊý¾ÝÄ£ÐͳÆÎª____________¡£

3¡¢ÔÚ¹ØÏµÊý¾Ý¿âµÄ»ù±¾²Ù×÷ÖУ¬´Ó±íÖÐÈ¡³öÂú×ãÌõ¼þÔª×éµÄ²Ù×÷³ÆÎª____________¡£ 4¡¢Èç¹ûÔÚVFP6.0µÄÃüÁî´°¿ÚϼüÈëÃüÁî_______£¬ÔòÍ˳öVFP6.0¡£

5¡¢Ã¿¸öÊý¾Ý¿âÎļþ×î¶à¿ÉÈÝÄÉ________ÒÚÌõ¼Ç¼¡£Ã¿Ìõ¼Ç¼×î¶à¿ÉÓÃ_______¸ö×ֶΡ£Ã¿Ìõ¼Ç¼×î¶àÄܰüº¬_________¸ö×Ö½Ú¡£Ã¿¸öÊý¾Ý¿âÎļþ×î¶àÄÜÈÝÄÉ____ÒÚ¸ö×Ö½Ú¡£ 6¡¢ÏîÄ¿ÎļþʹÓõÄÀ©Õ¹ÃûÊÇ________£¬ÏîÄ¿ÎļþµÄ˵Ã÷ÎļþµÄÀ©Õ¹ÃûÊÇ______¡£ 7¡¢´´½¨ÏîÄ¿Îļþʱ£¬¿ÉʹÓÃÃüÁîµÄÊÇ_______¡£ 8¡¢ ÁоÙvfpµÄÖ÷ÒªÉè¼ÆÆ÷£¨²»ÉÙÓÚ6ÖÖ£© ¡£ 9¡¢Ò»¸ö×Ö·û´®ÖÐ×î¶à¿É°üº¬_____¸ö×Ö·û£¬»ò°üº¬_____¸öºº×Ö¡£

10¡¢µ±¶¨½ç·ûÄÚ²»°üº¬ÈκÎ×Ö·ûʱ£¬³ÆÎª¿Õ×Ö·û´®¡£¿Õ×Ö·û´®µÄ³¤¶ÈΪ______¡£ 11¡¢ÈÕÆÚÐÍÊý¾ÝÊÇÓÃÀ´±íʾÈÕÆÚµÄÒ»ÖÖÌØÊâÊý¾Ý£¬Æä³¤¶È¹Ì¶¨Îª_____¸ö×Ö½Ú¡£ 12¡¢VFP6.0ÓÐÁ½ÖÖÐÔÖʵıäÁ¿£¬¼´_____ºÍ_______¡£

13¡¢Êý×éÔÚʹÓÃ֮ǰ¿ÉʹÓà ÃüÁîÀ´¶¨Òå¡£ 14¡¢×ֶαäÁ¿µÄÃû³ÆÓëÀàÐÍÊÇÔÚ½¨Á¢____________ʱ½øÐж¨ÒåµÄ¡£ 15¡¢Èç¹ûÄÚ´æ±äÁ¿Óë×ֶαäÁ¿³öÏÖͬÃû±äÁ¿£¬¿ÉÔÚÄÚ´æ±äÁ¿Ç°Ãæ¼ÓÉϱêÖ¾____À´Ìرð˵Ã÷¸Ã±äÁ¿ÊÇÄÚ´æ±äÁ¿¡£

16¡¢Òª¶¨ÖÆ×Ô¼ºµÄϵͳ»·¾³Ó¦µ¥»÷ ²Ëµ¥Ï嵀 ²Ëµ¥Ïî¡£

17¡¢Ö´ÐÐSTORE 230 TO S£¬N£¬M ÕâÌõÃüÁîºó£¬±äÁ¿NµÄÖµÊÇ_________¡£ 18¡¢ÓùØÏµÔËËã·û¶Ô×Ö·û´®½øÐбȽÏʱ£¬°´´Ó×óµ½ÓÒµÄ˳ÐòÖð¸ö¶Ô×Ö·ûµÄ____ÂëÖµµÄ´óС½øÐбȽϡ£ Èý¡¢¼ò´ðÌâ

1¡¢ VFP6.0ϵͳÖÐÒ»ÌõÃüÁîÓɼ¸²¿·Ö×é³É£¬¸÷²¿·ÖµÄº¬ÒåÊÇʲô£¿£¨²Î¿¼µÚÈýÕ£© 2¡¢Êý¾Ý´¦Àí¼¼Êõ¾­ÀúÁËÄö½×¶Î£¿ 3¡¢±äÁ¿µÄÃüÃû¹æÔòÓÐÄÄЩ£¿ÊÔ¾ÙÀý˵Ã÷¡£

4¡¢¼òÊöÊý¾Ý¿â¡¢Êý¾Ý±í¡¢¼Ç¼¡¢×Ö¶ÎÖ®¼äµÄ¹ØÏµ¡£

VFPµÚ¶þµ¥ÔªÁ·Ï°Ìâ

Ò»¡¢ Ìî¿ÕÌâ

1¡¢ Óöþά±íÀ´±íʾʵÌ弰ʵÌåÖ®¼äÁªÏµµÄÊý¾ÝÄ£ÐͳÆÎª 2¡¢ DB,DBS,DBMSÈýÕßÖ®¼äµÄ¹ØÏµÊÇ_________ 3¡¢ Êý¾Ý¿âϵͳÓëÎļþϵͳµÄÖ÷񻂿±ðΪ_________ 4¡¢ ¹ØÏµÊÇÖ¸___________________________ 5¡¢ ¹ØÏµÊý¾Ý¿âµÄÈýÖÖ»ù±¾ÔËËãΪ__________________

6¡¢ 7¡¢ 8¡¢ 9¡¢ 10¡¢ 11¡¢ 12¡¢ 13¡¢ 14¡¢ 15¡¢ 16¡¢ 17¡¢

18¡¢ 19¡¢ 20¡¢ 21¡¢ 22¡¢ 23¡¢ 24¡¢ 25¡¢ 26¡¢ 27¡¢ 28¡¢ 29¡¢ 30¡¢ 31¡¢ 32¡¢ 33¡¢ 34¡¢ 35¡¢

¶þ¡¢ ÉÏ»úÌ⣨ÉÏ»úÖ´ÐÐÏÂÁÐÃüÁ

1¡¢ A=dtoc(date())

?¡±today is ¡±+A

2¡¢ X=str(12.4,4,1)

Y=right(X,3) Z=¡±&y+&x¡± ?z,&z

3¡¢£¿at(¡°ÈËÃñ¡±,¡±ÖлªÈËÃñ¹²ºÍ¹ú¡±) 4¡¢£¿val(substr(¡°668899¡±,5,2))+1 5¡¢ÈÎÒâ´ò¿ªÒ»ÕÅ±í£¬Ö´ÐÐÏÂÁÐÃüÁî

Êý¾Ý¿âϵͳµÄºËÐÄΪ__________________

ÔÚ¹ØÏµÊý¾Ý¿âµÄ»ù±¾²Ù×÷ÖУ¬´Ó±íÖÐÈ¡³öÂú×ãÌõ¼þÔª×éµÄ²Ù×÷³ÆÎª_________ VFPÖв»ÔÊÐíÔÚÖ÷¹Ø¼ü×ÖÖÐÓÐÖØ¸´Öµ»ò_________ ÔÚVFPϵͳÖУ¬Êý¾Ý±í¿É·ÖΪ____ºÍ_____

ʵÌåÖ®¼äµÄÁªÏµ°üÀ¨___________________________ ¹Ø¼ü×ÖÊÇÖ¸_________

ÔÚVFPÖУ¬Ë÷ÒýÎļþÓÐ___________ºÍ_______ Êý¾ÝÍêÕûÐÔÖ¸µÄÊÇ___________________________ £¬Ëü°üº¬µÄÈýÖÖ¹æÔò·Ö±ðÊÇ__________¡¢____________¡¢____________¡£ ÏîÄ¿¹ÜÀíÆ÷ÊÇÖ¸___________________________

ÁоÙvfpµÄÖ÷ÒªÉè¼ÆÆ÷£¨²»ÉÙÓÚ6ÖÖ£©__________________ VFPÖоø¶ÔÒÆ¶¯¼Ç¼ָÕëµÄÃüÁî____ £¬VFPÖÐÏà¶ÔÒÆ¶¯¼Ç¼ָÕëµÄÃüÁî______ ÁоÙÏîÄ¿¹ÜÀíÆ÷ËùÓÐÑ¡Ï__________________ ÆäÖÐÎĵµÑ¡Ï°üÀ¨_________ Êý¾ÝÑ¡Ï°üÀ¨_________ ´úÂëÑ¡Ï°üÀ¨___________________________

µ¥¶ÀÉèÖÃÖ÷¿ØË÷ÒýµÄÃüÁîÊÇ___________________¡£

ÒªÉèÖÃÈÕÆÚºÍʱ¼äµÄÏÔʾ¸ñʽ£¬Ó¦Ñ¡Ôñ¡°Ñ¡Ï¶Ô»°¿òµÄ_________Ñ¡Ï ÏîÄ¿ÎļþµÄÀ©Õ¹ÃûΪ_________

Êý×éÔÚʹÓÃ֮ǰһ°ãÒªÓÃ_________ ÃüÁîÏÔʽ´´½¨ £¿round(337.2007,3)µÄ½á¹ûΪ__________________ £¿len(¡°this is my book¡±)µÄ½á¹ûΪ_________ time()·µ»ØÖµµÄÊý¾ÝÀàÐÍÊÇ_________

x=¡±a ¡±,?iif(¡°a¡±=x,x-¡°bcd¡±,x+¡±bcd¡±)µÄ½á¹ûΪ_________ n=886,m=345,k=¡±m+n¡±,±í´ïʽ1+&kµÄֵΪ_________

ÈÕÆÚÐÍ¡¢»õ±ÒÐÍ¡¢±¸×¢ÐÍ¡¢Í¨ÓÃÐÍÊý¾ÝÀàÐ͵ķûºÅ±íʾΪ__________________ ?between(20,13,16)µÄ½á¹ûΪ_________ ?mod(9,-2)µÄ½á¹ûΪ_________

º¯Êýdate()µÄº¯ÊýÖµµÄÀàÐÍΪ_________

?int(3.69)µÄ½á¹ûΪ_________ ?substr(¡°conclusion¡±,7)µÄ½á¹ûΪ_________ £¿occurs(¡°a¡±,¡±abbacda¡±) µÄ½á¹ûΪ_________ ?like(¡°china¡±,¡±chinese¡±) µÄ½á¹ûΪ_________ ?val(¡°33.123¡±) µÄ½á¹ûΪ_________

go top ?recno() ?bof() ?eof() go bottom ?recno() ?bof() ?eof()

6¡¢ÈÎÒâ´ò¿ªÒ»ÕÅ±í£¬Í¨¹ýGATHERÃüÁî°ÑÊý×éÊý¾Ý¸´ÖƵ½±íµÄµ±Ç°¼ÆÂ¼¡£ 7¡¢ÈÎÒâ´ò¿ªÒ»ÕÅ±í£¬°Ñµ±Ç°¼Ç¼¸´ÖƵ½Êý×éa£¬²¢ÏÔʾÊý×éaµÄ¸÷¸öÔªËØ¡£ 8¡¢Á·Ï°Ê¹ÓÃÏîÄ¿¹ÜÀíÆ÷ϵÄн¨¡¢Ìí¼Ó¡¢Ð޸ġ¢ÔËÐС¢Á¬±àÃüÁî°´Å¥¡£

9¡¢ÉÏ»úÊìϤ¹¤¾ß²Ëµ¥ÏµÄÑ¡Ïî¶Ô»°¿òµÄ¸÷¸ö×÷Óã¬ÌرðÊÇÇøÓò¡¢ÎļþλÖᢳ£¹æÑ¡ÏµÄ×÷Óá£

µÚÎåÕÂÁ·Ï°Ì⸽´ð°¸ µ¥Ñ¡Ìâ

1£®SQLµÄºËÐŦÄÜÊÇ( ) A

(A)Êý¾Ý²éѯ (B)Êý¾ÝÐÞ¸Ä (C)Êý¾Ý¶¨Òå(D)Êý¾Ý¿ØÖÆ 2.SQLÓïÑÔÊÇÒ»ÖÖ( )µÄÓïÑÔ¡£A

(A)¹ØÏµÐÍÊý¾Ý¿â (B)Íø×´ÐÍÊý¾Ý¿â (C)²ã´ÎÐÍÊý¾Ý¿â (D)·Ç¹ØÏµÐÍÊý¾Ý¿â 3£®ÔÚSQL²éѯʱ£¬Ê¹ÓÃWHERE×Ó¾äÖ¸³öµÄÊÇ( ) (A)²éѯĿ±ê (B)²éѯ½á¹û (C)²éѯÌõ¼þ (D)²éѯÊÓͼ 4£®SQLÓï¾äÖÐʵÏÖ·Ö×é²éѯµÄ¶ÌÓïÊÇ( )

(A)order by (B)group by (C)having (D)asc

5.ͳ¼Æ±í¡°¹¤×Ê¡±Öи÷¡°²¿ÃÅ¡±µÄ¡®Ó¦Á칤×Ê¡¯×ܶʹÓÃSQLÓï¾ä( ) (A)sele²¿ÃÅ£¬Ó¦Á칤×Ê from ¹¤×Ê orde by ²¿ÃÅ

(B)sele²¿ÃÅ£¬sum(Ó¦Á칤×Ê) from ¹¤×Ê orde by ²¿ÃÅ (C)sele²¿ÃÅ£¬Ó¦Á칤×Ê from ¹¤×Ê group by ²¿ÃÅ (D)sele²¿ÃÅ£¬sum(Ó¦Á칤×Ê) from ¹¤×Ê group by ²¿ÃÅ 6.SQL²éѯÓï¾äÖУ¬( )ÓÃÓÚÖ¸¶¨²éѯ½á¹ûÖмǼµÄÏÔʾÊýÁ¿¡£ (A)where (B)TOP (C)from (D)SUM 7.¶à±í²éѯ±ØÐëÉ趨µÄÑ¡ÏΪ( ) (A)×Ö¶Î (B)ɸѡ (C)¸üÐÂÌõ¼þ (D)Áª½Ó

8.²éѯ±íSTOCKÖÐÿ¸ö¡°½»Ò×Ëù¡±µÄƽ¾ù¡°µ¥¼Û¡±µÄSQLÓï¾äÊÇ( ) (A)SELE ½»Ò×Ëù,AVG(µ¥¼Û) FROM STOCK GROUP BY µ¥¼Û (B)SELE ½»Ò×Ëù,AVG(µ¥¼Û) FROM STOCK ORDER BY µ¥¼Û (C)SELE ½»Ò×Ëù,AVG(µ¥¼Û) FROM STOCK ORDER BY ½»Ò×Ëù (D)SELE ½»Ò×Ëù,AVG(µ¥¼Û) FROM STOCK GROUP BY ½»Ò×Ëù 9£®SQLÓï¾äÖеÄÊý¾Ý²Ù×ÝÃüÁî²»°üÀ¨( )

(A)INSERT-SQL (B)CHANGE-SQL (C)DELETE-SQL (D)UPDATE-SQL 10£®SQL²éѯÖУ¬ÓÃÓÚÅÅÐòºÍÈ¥µôÖØ¸´¼Ç¼µÄÑ¡Ïî×Ó¾ä·Ö±ðÊÇ£¨ £©

A ORDER BYºÍJOIN B GROUP BYºÍDISTINCT C ORDER BYºÍDISTINCT D ORDER BY ºÍGROUP BY Ìî¿ÕÌâ

1£®ÉèÊý¾Ý±íSTUD.DBFÓÐ×ֶΣºÑ§ºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬ÄêÁ䣬Ãñ×壬רҵ£¬³É¼¨µÈ×ֶΡ£ÏÂÃæ

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