SQL--insert new data to table

1. insert new data to table, 先删除再添加

BEGIN TRY
BEGIN TRANSACTION 

	DELETE FROM [dbo].[MT_Sch] WHERE Code=2 AND Sequence IN ('A1','B2','C3')
	
	INSERT INTO [dbo].[MT_Sch]
	([Code],[Sequence],[Status],[Updated_date],[Updated_by])
	VALUES
	(2,'A1','A',GETDATE(),'System'),
	(2,'B2','A',GETDATE(),'System'),
	(2,'C3','A',GETDATE(),'System')
  
COMMIT
END TRY
BEGIN CATCH

    IF @@ERROR <> 0 
        ROLLBACK
END CATCH  

2. insert new data to table, 如果存在就修改， 如果不存在就添加

BEGIN TRY
BEGIN TRANSACTION 
  
	IF EXISTS (SELECT 1 FROM [dbo].[Message] WHERE Code =17)
		BEGIN
			UPDATE [dbo].[Message] SET Desc ='Test Case For My Blog.',Updated_date=GETDATE()
			WHERE Code=17
		END
	ELSE
		INSERT INTO [dbo].[Message]
		([Desc],[Updated_date],[Updated_by])
		values
		('Test Case For My Blog.',GETDATE(),'Admin')  

COMMIT
END TRY
BEGIN CATCH

    IF @@ERROR <> 0 
        ROLLBACK
END CATCH