Example Table in SQL Server for Replication test

CREATE TABLE ExampleTable (

    ID INT PRIMARY KEY,

    Name NVARCHAR(50),

    Age INT

);

INSERT INTO ExampleTable (ID, Name, Age) VALUES

(1, 'John', 30),

(2, 'Alice', 25),

(3, 'Bob', 35),

(4, 'Emily', 28),

(5, 'Michael', 40),

(6, 'Samantha', 32),

(7, 'David', 22),

(8, 'Sophia', 27),

(9, 'Daniel', 38),

(10, 'Olivia', 31);

SELECT * FROM ExampleTable

UPDATE ExampleTable

SET Name = CASE

    WHEN ID = 1 THEN 'Rahul Kumar'

    WHEN ID = 2 THEN 'Pooja Sharma'

    WHEN ID = 3 THEN 'Vinay Patil'

    WHEN ID = 4 THEN 'Sonia Yadav'

    WHEN ID = 5 THEN 'Rajesh Singh'

    WHEN ID = 6 THEN 'Priyanka Gupta'

    WHEN ID = 7 THEN 'Amit Jain'

    WHEN ID = 8 THEN 'Deepak Mishra'

    WHEN ID = 9 THEN 'Anita Rajput'

    WHEN ID = 10 THEN 'Suresh Yadav'

    ELSE Name

END;

UPDATE ExampleTable SET Name = 'Venkat Kumar' WHERE ID = 1;

UPDATE ExampleTable SET Name = 'Sarath Chandra' WHERE ID = 10;