CREATE TABLE MaTable ( ID int, Dat int );
DECLARE @n_ID int; DECLARE @n_Dat int; SET @n_ID = XXX; SET @n_Dat = YYY; BEGIN TRAN; IF EXISTS( SELECT 1 FROM MaTable WHERE ID = @n_ID ) BEGIN UPDATE MaTable SET Dat = @n_Dat WHERE ID = @n_ID; END ELSE BEGIN INSERT INTO MaTable ( ID, Dat ) VALUES ( @n_ID, @n_Dat ); END COMMIT TRAN;