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