SQL教学课程存储过程公开课获奖课件.pptVIP

第六章;回忆;本章目旳;;;;;EXECsp_databases

EXECsp_renamedbNorthwind,Northwind1

USEstuDB

GO

EXECsp_tables

EXECsp_columnsstuInfo

EXECsp_helpstuInfo

EXECsp_helpconstraintstuInfo

EXECsp_helpindexstuMarks

EXECsp_helptextview_stuInfo_stuMarks

EXECsp_stored_procedures;;;;创立不带参数寄存过程2-1;创立不带参数寄存过程2-2;;;;;;输入参数默认值3-1;;;;CREATEPROCEDUREproc_stu

@notpassSumintOUTPUT,

@writtenPassint=60,

@labPassint=60

AS

……

SELECTstuName,stuInfo.stuNo,writtenExam,

labExamFROMstuInfoINNERJOINstuMarks

ONstuInfo.stuNo=stuMarks.stuNo

WHEREwr