神马作文网1.编程题：将下列函数用分支结构语句进行改写——————————
来源：学生作业帮 编辑：神马作文网作业帮 分类：综合作业 时间：2024/10/05 11:23:08
1.编程题：将下列函数用分支结构语句进行改写——————————
答：IIF(CJ<60,"不合格",IIF(CJ>=90,"优秀","合格"))
2.读下列程序写出最后执行结果__________________________.
SET TALK OFF
a=3
b=4
DO SUB_1 WITH (a),b
"a=",a,"b=",b
SET TALK ON
*SUB_1.PRG
Proce sub_1
PARAMETERS x,y
y=x*y
RETURN
3、在SQL查询中,查询结果默认显示在浏览窗口中.在实际应用中,用户还可以将查询结果保存在指定目标中.请列举五种查询结果的输出目标及使用的关键词.
4、现有两个数据表STUD和TEACHER如图所示,请写出SELECT-SQL查询语句以实现试题中所要求的查询.
1）查询所有姓“张”的学生的记录的全部资料._______________________________________
2）查询成绩在500分和600分之间的学生的学号、姓名、班级和成绩.___________________
3）查询计算机系所有教师的基本情况.____________________________________________
4）向学生表中插入一条新记录（“6198101”,“张峰”,“61981”,560,“61981f”）._________
5）查询建设系所有教师的教师名、工资信息,并按照工资由高到低排序._________________
答：IIF(CJ<60,"不合格",IIF(CJ>=90,"优秀","合格"))
2.读下列程序写出最后执行结果__________________________.
SET TALK OFF
a=3
b=4
DO SUB_1 WITH (a),b
"a=",a,"b=",b
SET TALK ON
*SUB_1.PRG
Proce sub_1
PARAMETERS x,y
y=x*y
RETURN
3、在SQL查询中,查询结果默认显示在浏览窗口中.在实际应用中,用户还可以将查询结果保存在指定目标中.请列举五种查询结果的输出目标及使用的关键词.
4、现有两个数据表STUD和TEACHER如图所示,请写出SELECT-SQL查询语句以实现试题中所要求的查询.
1）查询所有姓“张”的学生的记录的全部资料._______________________________________
2）查询成绩在500分和600分之间的学生的学号、姓名、班级和成绩.___________________
3）查询计算机系所有教师的基本情况.____________________________________________
4）向学生表中插入一条新记录（“6198101”,“张峰”,“61981”,560,“61981f”）._________
5）查询建设系所有教师的教师名、工资信息,并按照工资由高到低排序._________________
1.if CJ = 90 ?"优秀" else ?"合格" endifendif
2.a=3 b=12
3.copy to filenamecopy to array arrayname
4. 1)select * from stud where 姓名 like '张%' 2)select 学号,姓名,班级,成绩 from stud where 成绩 between 500 and 600 3)select * from teacher where 系别='计算机' 4)insert into stud values ("6198101","张峰","61981",560,"61981f") 5)select 教师名,工资 from teacher order by 工资 desc
再问： ���ʣ���������پ������
再答： 附件是VFP帮助文档， 在索引中输入“COPY TO”,可看到如下说明,具体哪5种，我也不太清楚。COPY TO FileName [DATABASE DatabaseName [NAME LongTableName]]
[FIELDS FieldList | FIELDS LIKE Skeleton | FIELDS EXCEPT Skeleton]
[Scope] [FOR lExpression1] [WHILE lExpression2]
[ [WITH] CDX ] | [ [WITH] PRODUCTION ] [NOOPTIMIZE]
[ [TYPE] [ FOXPLUS | FOX2X | DIF | MOD | SDF | SYLK | WK1 | WKS | WR1
| WRK | CSV | XLS | XL5 | DELIMITED [ WITH Delimiter | WITH BLANK
| WITH TAB | WITH CHARACTER Delimiter ] ] ] [AS nCodePage]
2.a=3 b=12
3.copy to filenamecopy to array arrayname
4. 1)select * from stud where 姓名 like '张%' 2)select 学号,姓名,班级,成绩 from stud where 成绩 between 500 and 600 3)select * from teacher where 系别='计算机' 4)insert into stud values ("6198101","张峰","61981",560,"61981f") 5)select 教师名,工资 from teacher order by 工资 desc
再问： ���ʣ���������پ������
再答： 附件是VFP帮助文档， 在索引中输入“COPY TO”,可看到如下说明,具体哪5种，我也不太清楚。COPY TO FileName [DATABASE DatabaseName [NAME LongTableName]]
[FIELDS FieldList | FIELDS LIKE Skeleton | FIELDS EXCEPT Skeleton]
[Scope] [FOR lExpression1] [WHILE lExpression2]
[ [WITH] CDX ] | [ [WITH] PRODUCTION ] [NOOPTIMIZE]
[ [TYPE] [ FOXPLUS | FOX2X | DIF | MOD | SDF | SYLK | WK1 | WKS | WR1
| WRK | CSV | XLS | XL5 | DELIMITED [ WITH Delimiter | WITH BLANK
| WITH TAB | WITH CHARACTER Delimiter ] ] ] [AS nCodePage]