usp_insertuser.sql

Beginning VB.NET DatabasesAll_Code.rar

CREATE  PROCEDURE usp_InsertUser
(
   @UserID      UNIQUEIDENTIFIER,
   @LoginName   VARCHAR(15),
   @Password    VARCHAR(30),
   @FirstName   VARCHAR(15),
   @LastName    VARCHAR(15),
   @Email       VARCHAR(50),
   @Phone       VARCHAR(20),
   @Status      BIT,
   @GroupID     UNIQUEIDENTIFIER,
   @RoleID      UNIQUEIDENTIFIER,
   @ManagerID   UNIQUEIDENTIFIER
)
AS
INSERT INTO Users
   (UserID, LoginName, Password, FirstName, LastName, Email,
   Phone, Status, GroupID, RoleID, ManagerID, LastUpdateDate)
   VALUES(@UserID, @LoginName, @Password, @FirstName, @LastName, @Email,
   @Phone, @Status, @GroupID, @RoleID, @ManagerID, GETDATE())