usp_insertrole.sql

数据库学习的绝好例子简单的数据库经典入门

ALTER PROCEDURE usp_InsertRole
(
   @RoleID            UNIQUEIDENTIFIER,
   @RoleName          VARCHAR(50),
   @RoleDescription   TEXT,
   @Ranking           TINYINT
)
AS
IF EXISTS (SELECT Ranking FROM Roles WHERE Ranking = @Ranking)
   BEGIN
   RAISERROR('Ranking already exists and cannot be duplicated',18,1)
   END
ELSE
   BEGIN
   BEGIN TRY
      INSERT INTO Roles
         (RoleID, RoleName, RoleDescription, Ranking, LastUpdateDate)
         VALUES(@RoleID, @RoleName, @RoleDescription, @Ranking, GETDATE())
   END TRY
   BEGIN CATCH
      RAISERROR('Insert into Roles failed.',18,1)
   END CATCH
   END