增删改查存储过程案例

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
复制代码