1、实验七创建和操作数据库对象云南大学软件学院实 验 报 告课程: 数据库原理与实用技术实验 任课教师: 张璇, 刘宇 专业: 软件工程 学号: 姓名: 成绩: 实验7 创建和操作数据库对象分号;SQL语句进行分隔(不是必须的,但是良好的习惯)带输入/输出参数的存储过程1.只有输出参数(执行存储过程时按顺序填充参数)create proc grad(max_grade int output,min_grade int output)asselect max_grade=MAX(grade)from gradesselect min_grade=MIN(grade)from gradesreturn
2、godeclare max_grade int,min_grade intexec grad max_grade output,min_grade outputselect max_grade,min_grade2.有输入输出参数(执行存储过程时按顺序填充参数)CREATE PROC my_procage name nchar(20),age int OUTPUTASif not exists(SELECT * FROM students WHERE stud_name = name) return -101SELECT age = ageFROM studentsWHERE stud_nam
3、e = namereturnGODECLARE stud_age int,status intEXEC status=my_procage 葛文卿, stud_age OUTPUTif status=-101 print no that person!else print the student age is:+convert(varchar(10),stud_age)with check optionCREATE VIEW custviewASSELECT * FROM customers WHERE discnt =0 AND percent =10with check option7.9:答:违反了规则5,不能够含有salary1+salary2这种列,这样的话,如果我们对视图 进行更新以后就无法使原始表进行同步的更新,因为知道salary1+salary2的值, 无法知道salary1与salary2人别的值。7.12:CREATE VIEW custviewASSELECT * FROM customers WHERE discnt 12.0with check optionSELECT * FROM custviewupdate custviewset discnt = 13.0where cid = c001select * from customersdrop