spAddUpdate_FacebookClientUsers
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @UserID | int | IN | |
| @FacebookUserID | nvarchar(50) | IN |
Definition
Copy
CREATE PROCEDURE dbo.spAddUpdate_FacebookClientUsers
(
@UserID int,
@FacebookUserID nvarchar(50)
)
AS
BEGIN
DECLARE @ID int
SELECT @ID = FacebookUserID FROM FacebookClientUsers WHERE [ClientUsersID] = @UserID
if @ID > 0
begin
if @ID <> @FacebookUserID
begin
UPDATE FacebookClientUsers SET FacebookUserID = @FacebookUserID WHERE ClientUsersID = @UserID
end
END
else
begin
INSERT INTO FacebookClientUsers (ClientUsersID, FacebookUserID) VALUES (@UserID, @FacebookUserID)
end
END