为超市会员管理系统写三个存储过程,需要些调用语句
时间: 2024-03-27 19:42:08 浏览: 14
存储过程1:添加新会员
```
CREATE PROCEDURE add_new_member
@name varchar(50),
@gender varchar(10),
@age int,
@phone varchar(20),
@email varchar(50),
@address varchar(100)
AS
BEGIN
INSERT INTO Member (Name, Gender, Age, Phone, Email, Address)
VALUES (@name, @gender, @age, @phone, @email, @address)
END
```
调用语句:
```
EXEC add_new_member '张三', '男', 25, '13912345678', 'zhangsan@qq.com', '北京市海淀区'
```
存储过程2:修改会员信息
```
CREATE PROCEDURE update_member_info
@id int,
@name varchar(50),
@gender varchar(10),
@age int,
@phone varchar(20),
@email varchar(50),
@address varchar(100)
AS
BEGIN
UPDATE Member
SET Name = @name, Gender = @gender, Age = @age, Phone = @phone, Email = @email,
Address = @address
WHERE Id = @id
END
```
调用语句:
```
EXEC update_member_info 1, '李四', '女', 30, '13612345678', 'lisi@qq.com', '上海市浦东新区'
```
存储过程3:删除会员
```
CREATE PROCEDURE delete_member
@id int
AS
BEGIN
DELETE FROM Member WHERE Id = @id
END
```
调用语句:
```
EXEC delete_member 1
```
相关推荐
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)