SamplesV2/ChangeDataCapture/usecases/cdc/code/sqlscripts/spUpdateWatermark.sql (7 lines of code) (raw):
CREATE PROCEDURE spUpdateWatermark @LastModifyDate datetime, @PartitionID INT
AS
BEGIN
UPDATE [ControlTableForSourceToSink]
SET [WatermarkValue] = @LastModifyDate
WHERE PartitionID = @PartitionID
END