资源描述：
《sql2008课后习题答案实验7》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、SQL2008课后习题答案实验71.storedprocedures1>createsastoredprocedurethatinitializesalocalvariableusingthenumberofemployeesintheEmployeestable,andcallsthestoredprocedureCreate,procedure,test,@numberl,int,outputAsBeginDeclare@number2intSet@number2=(selectCOUNT(*)fromEmployees)Set@numberl=@number2EndExecut
2、ethestoredprocedureandseetheresults:Declare@numintExectest@numoutputSelect@num2>createastoredprocedure,comparethetwoemployeesofrealincome,iftheformerthanthelatterasoutput0,otherwiseoutput1;Create,procedure,COMPA,@ID1,char(6),@ID2,char(6),@BJ,int,outputAsBeginDeclare,@SR1,float,@SR2,floatSelect,
3、@SRl=InCome-OutCome,from,Salary,where,EmployeeID=@IDlSelect,@SR2=InCome-OutCome,from,Salary,where,EmployeeID=@ID2If@ID1>@ID2Set@BJ二0ElseSet@BJ二1EndExecutethestoredprocedureandseetheresults;Declare@BJintExec,COMPA,'000001',T08991',@BJ,outputSelect@BJ3>createsastoredprocedurethataddsstaffrecordst
4、oEmploeeAdd;CreateprocedureEmployeeAdd(@EmployeeID,char(6),@Name,char(10),@Education,char(4),@Birthday,datetime,@WorkYear,tinyint,@Sex,bit,@Address,char(40),@PhoneNumber,char(12),©DepartmentIDchar(3)As)BeginInsertintoEmployeesValues(@EmployeeID,@Name,©Education,@Birthday,@WorkYear,@Sex,@Address
5、,@PhoneNumber,@DepartmentID)EndReturnGoExecutethestoredprocedure;Exec,EmployeeAdd,'990230','LiuChao','BachelorJ'840909,,2,1,?HongwulittleHongshan5'85465213'3'4>createsastoredprocedurewiththeoutputcursorparameter,declaringandopeningacursorintheEmployeestable;Create,procedure,em_cursor,@em_cursor
6、,cursor,varying,outputAsBeginSet@em_cursor=CURSORforward_onlystaticFORSelect*fromEmployeesOpen@em_cursorEndDeclarealocalcursorvariable,executethestoredprocedure,assignthecursortothelocalcursorvariable,andthenreadtherecordthroughthecursorvariable;Declare@MyCursorcursorExecem_cursor@em_cursor=@My
7、CursoroutputFetchnextfrom@MyCursorWh订e(@@FETCH_STATUS=O)BeginFetchnextfrom@MyCursorEndClose@MyCursorDeallocate@MyCursorGo5>createsastoredprocedurethatusescursorstodeterminewhetheranemployee，sactualincomeisinthetopthree・Theresultis
