usp_updateuser.sql

来自「Beginning VB.NET DatabasesAll_Code.rar」· SQL 代码 · 共 36 行

CREATE PROCEDURE usp_UpdateUser
(
   @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

UPDATE Users
   SET LoginName = @LoginName, 
   Password = @Password, 
   FirstName = @FirstName, 
   LastName = @LastName,
   Email = @Email, 
   Phone = @Phone, 
   Status = @Status, 
   GroupID = @GroupID, 
   RoleID = @RoleID, 
   ManagerID = @ManagerID, 
   LastUpdateDate = GETDATE()
   WHERE UserID = @UserID

IF @@ERROR <> 0 
   BEGIN
   RAISERROR('Update user failed.',18,1)
   RETURN
   END