usp_insertrole.sql

Beginning VB.NET DatabasesAll_Code.rar

CREATE PROCEDURE usp_InsertRole
(
   @RoleID            UNIQUEIDENTIFIER,
   @RoleName          VARCHAR(50),
   @RoleDescription   TEXT,
   @Ranking           TINYINT
)
AS
INSERT INTO Roles
   (RoleID, RoleName, RoleDescription, Ranking, LastUpdateDate)
   VALUES(@RoleID, @RoleName, @RoleDescription, @Ranking, GETDATE())