From the below table how to update the item column to null for all rows using merge update statement ID Product Items 1 Product1 2 2 Product2 2 3 Product3 2 4 Product4 1 5 Product5 1 Thanks

MERGE INTO YourTable AS Target USING ( SELECT ID FROM YourTable ) AS Source ON (Target.ID = Source.ID) WHEN MATCHED THEN UPDATE SET Target.Items = NULL;

MERGE INTO product AS Target USING (SELECT ID FROM product) AS Source ON Target.ID = Source.ID WHEN MATCHED THEN UPDATE SET Target.Items = NULL;

You can update the "Items" column to NULL for all rows in the table using a simple SQL UPDATE statement. There's no need to use a MERGE statement for this task. Here's the SQL statement to achieve this: UPDATE YourTableName SET Items = NULL; Replace YourTableName with the actual name of your table. This query will set the "Items" column to NULL for all rows in the table, effectively clearing the "Items" column for all records.