mysql实验8 实验九_数据库实验8答案

最新推荐文章于 2021-03-23 23:33:23 发布

weixin_39573822

最新推荐文章于 2021-03-23 23:33:23 发布

阅读量676

点赞数

文章标签： mysql实验8 实验九

本文链接：https://blog.csdn.net/weixin_39573822/article/details/114841301

版权

8.2.3 实验内容

请完成以下实验内容：

(1)利用游标查找所有女业务员的基本情况。

declare @employeeNo char(8) , @employeeName varchar(10), @sex char(1)

declare @birthday datetime , @address varchar(50) , @telephone varchar(20)

declare @hireDate datetime , @department varchar(30), @headShip varchar(10),

declare @salary numeric(8,2)

DECLARE curEmployee CURSOR FOR

SELECT *

FROM Employee

WHERE sex='F' and department='业务科'

OPEN curEmployee

FETCH curEmployee INTO @employeeNo,@employeeName ,@sex ,@birthday , @address ,@telephone ,@hireDate,@department , @headShip ,@salary WHILE(@@FETCH_STA TUS=0)

BEGIN

SELECT @employeeNo,@employeeName ,@sex , @birthday ,

@address ,@telephone ,@hireDate , @department , @headShip , @salary FETCH curEmployee INTO @employeeNo,@employeeName ,@sex ,@birthday , @address ,@telephone ,@hireDate,@department , @headShip ,@salary END

CLOSE curEmployee

DEALLOCATE curEmployee

结果：

(2) 创建一游标，逐行显示表Customer.的记录，要求按

'客户编号'+'------'+'客户名称'+'------'+'客户地址'+'-----------------------------------'+'客户电话'+'-------'+'客户邮编'+'------'格式输出，并且用WHILE结构来测试游标的函数@@Fetch_Status的返回值。

解1

DECLARE @CustomerNo char(9) ,@CustomerName varchar(40) , @telephone varchar(20),