usp_deleterole.sql

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

CREATE PROCEDURE usp_DeleteRole
(
   @RoleID   UNIQUEIDENTIFIER
)
AS

BEGIN TRY
   DELETE FROM ROles
   WHERE RoleID = @RoleID
END TRY
BEGIN CATCH
   BEGIN
   RAISERROR('Delete role failed.',18,1)
   RETURN
   END
END CATCH