spUpdateLimited_ClientUsers
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | int | IN | |
| @FirstName | nvarchar(50) | IN | |
| @MiddleInitial | nvarchar(5) | IN | |
| @LastName | nvarchar(50) | IN | |
| nchar | IN | ||
| @LinkedInProfileID | int | IN |
Definition
Copy
CREATE procedure dbo.SPUPDATELIMITED_CLIENTUSERS
(
@ID int,
@FirstName nvarchar(50),
@MiddleInitial nvarchar(5),
@LastName nvarchar(50),
@Email nchar(100),
@LinkedInProfileID int = 0
)
AS
BEGIN
DECLARE @hResult int /* COM Variable-Naming Convention */
SET @hResult = 0
BEGIN TRANSACTION
IF (@ID <= 0)
BEGIN
SET @hResult = -1
END
ELSE
BEGIN
UPDATE [dbo].ClientUsers
SET
FirstName = @FirstName,
MiddleInitial = @MiddleInitial,
LastName = @LastName,
Email = IsNull(@Email, Email),
LinkedInProfileID = @LinkedInProfileID
WHERE ID=@ID
IF (@@ERROR <> 0) SET @hResult = @@ERROR
END
COMMIT TRANSACTION
RETURN @hResult
END