SQL_Department / GetDepartments

最新推荐文章于 2021-09-14 22:15:11 发布

weixin_30546189

最新推荐文章于 2021-09-14 22:15:11 发布

阅读量272

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/xiyang120/archive/2010/12/13/1905125.html

本文介绍了如何使用SQL创建一个部门表并实现增删改查的基本操作。具体包括定义表结构、创建存储过程以获取所有部门信息，并通过插入示例数据来演示整个流程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SQL_

TABLE : Department

PROCEDURE : GetDepartments

CREATE TABLE Department(
	DepartmentID INT IDENTITY(1,1) NOT NULL,
	Name VARCHAR(50) NOT NULL,
	Description VARCHAR(1000) NULL,
 CONSTRAINT PK_Department PRIMARY KEY CLUSTERED (DepartmentID ASC)
)

GO

CREATE PROCEDURE GetDepartments AS
SELECT DepartmentID, Name, Description
FROM Department

GO

INSERT INTO Department(Name, Description)		
VALUES ('Anniversary Balloons', 'These sweet balloons are the perfect gift for someone you love.')
GO

INSERT INTO Department(Name, Description )		
VALUES ('Balloons for Children', 'The colorful and funny balloons will make any child smile!')
GO

转载于:https://www.cnblogs.com/xiyang120/archive/2010/12/13/1905125.html