CREATE PROCEDURE usp_Upsert_teste1_1 
@ID INT,
@Desc VARCHAR(100)
AS
IF EXISTS (SELECT TOP 1 1 FROM teste1 WHERE ID = @ID)
	UPDATE teste1 SET Description = @Desc WHERE ID = @ID
ELSE
	INSERT INTO teste1 (ID, Description) VALUES (@ID, @Desc)
GO
	
CREATE PROCEDURE usp_Upsert_teste1_2
@ID INT,
@Desc VARCHAR(100)
AS
MERGE teste1 AS target
USING (SELECT @ID, @Desc) AS source (ID, Dsc)
ON target.ID = source.ID
WHEN MATCHED THEN
	UPDATE SET target.Description = source.Dsc
WHEN NOT MATCHED THEN
	INSERT (ID, Description) VALUES (source.ID, source.Dsc);