SQL_Department / GetDepartments

最新推荐文章于 2024-06-17 09:51:17 发布

weixin_30546189

最新推荐文章于 2024-06-17 09:51:17 发布

阅读量236

点赞数

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

版权

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