CREATE PROCEDURE RegionUpdate (@RegionID INTEGER, @RegionDescription NCHAR(50))
AS SET NOCOUNT OFF
UPDATE Region
SET RegionDescription = @RegionDescription WHERE RegionID = @RegionID
GO
复制代码
CREATE PROCEDURE RegionDelete (@RegionID INTEGER)
AS SET NOCOUNT OFF
DELETE FROM Region WHERE RegionID = @RegionID
GO
复制代码
CREATE PROCEDURE RegionInsert (@RegionID INTEGER, @RegionDescription NCHAR(50))
AS SET NOCOUNT OFF
SELECT @RegionID = MAX(RegionID) + 1 FROM Region
INSERT INTO Region(RegionID, RegionDescription)
VALUES(@RegionID, @RegionDescription)
GO
复制代码
CREATE PROCEDURE RegionSelect AS
SET NOCOUNT OFF
SELECT * FROM Region
GO
复制代码