Home
> SQL Server > Easy SQL If Record Exists, Update It. If Not, Insert It.
Easy SQL If Record Exists, Update It. If Not, Insert It.
Hi
try this example :-
CREATE PROCEDURE dbo.spAddUser ( @UserID AS int, @FirstName AS varchar(50), @LastName AS varchar(50) ) AS BEGIN DECLARE @rc int UPDATE [Users] SET FirstName = @FirstName, LastName = @LastName WHERE UserID = @UserID /* how many rows were affected? */ SELECT @rc = @@ROWCOUNT IF @rc = 0 BEGIN INSERT INTO [Users] (FirstName, LastName) VALUES(@FirstName, LastName) END END
Hope this helps
Good Luck
Advertisements
Categories: SQL Server
or,
…
IF EXIST (SELECT 0 FROM [Users] WHERE UserID = @UserID) BEGIN
UPDATE [Users] SET …;
END ELSE BEGIN
INSERT INTO [Users]…;
END;
Or
Set @rc = (select count(*) from users where UserID = @UserID)
If @rc = 0
Begin — Insert new Record
End
Insert Into Users(……..)
Values (……..)
else
Begin — Update Existing Record
Update Users
Set ………
Where UserID = @UserID
End
Thanks both sergeos and Night Coder for your comments