IF EXISTS(SELECT * FROM Table1 WHERE Id = @id) BEGIN UPDATE Table1 SET Column1 = @newValue WHERE Id = @id END ELSE BEGIN INSERT INTO Table1 (Id, Column1) VALUES(@id, @newValue) END