Script.PostDeployment.sql update or insert (MERGE)

post_data.sql

MERGE INTO [TABLE_NAME]
USING (VALUES

    (1, 'some text', 'some value'),
    (2, 'some text', 'some value')
)
AS Source ([ID], [Text], [Value])
ON [TABLE].[ID] = Source.[ID]
-- update matched rows 
WHEN MATCHED THEN 
UPDATE SET 
[Text] = Source.[Text], 
[Value] = Source.[Value]
-- insert new rows 
WHEN NOT MATCHED BY TARGET THEN 
INSERT ([ID], [Text], [Value])
VALUES ([ID], [Text], [Value])

--Script.PostDeployment.sql
--BEGIN

--:r .\Data\post_data.sql

--END