2024年4月7日发(作者：小马win10激活工具官网下载)
sql procedure语句
1. 创建存储过程
```sql
CREATE PROCEDURE sp_create_table
AS
BEGIN
CREATE TABLE ee
(
ID INT PRIMARY KEY,
Name NVARCHAR(50),
Age INT,
Department NVARCHAR(50)
)
END
```
2. 查询存储过程
```sql
CREATE PROCEDURE sp_get_employee
AS
BEGIN
SELECT * FROM ee
END
```
3. 插入数据的存储过程
```sql
CREATE PROCEDURE sp_insert_employee
@ID INT,
@Name NVARCHAR(50),
@Age INT,
@Department NVARCHAR(50)
AS
BEGIN
INSERT INTO ee (ID, Name, Age, Department)
VALUES (@ID, @Name, @Age, @Department)
END
```
4. 更新数据的存储过程
```sql
CREATE PROCEDURE sp_update_employee
@ID INT,
@Age INT
AS
BEGIN
UPDATE ee
发布者：admin，转转请注明出处：http://www.yc00.com/xitong/1712482895a2067667.html
评论列表（0条）