?? storedprocs.sql
字號:
--
-- Procedure which inserts a region record and returns the key
--
CREATE PROCEDURE RegionInsert(@RegionDescription NCHAR(50),
@RegionID INTEGER OUTPUT)AS
SET NOCOUNT OFF;
SELECT @RegionID = MAX ( RegionID ) + 1
FROM Region ;
INSERT INTO Region(RegionID, RegionDescription)
VALUES(@RegionID, @RegionDescription);
GO
--
-- Procedure to update the description of a region
--
CREATE PROCEDURE RegionUpdate(@RegionID INTEGER,
@RegionDescription NCHAR(50))AS
SET NOCOUNT OFF;
UPDATE Region
SET RegionDescription = @RegionDescription
WHERE RegionID = @RegionID;
GO
--
-- Procedure to delete a region
--
CREATE PROCEDURE RegionDelete (@RegionID INTEGER) AS
SET NOCOUNT OFF;
DELETE FROM Region
WHERE RegionID = @RegionID;
GO
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -