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.

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;

Answers

SQL Upsert

sathish

604

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

Answers (4)

Next Recommended Forum

How to deleting backup files from a folder using SQL Server ?

Stored procedure for inserting data into table

Leaderboard

View all

Shubhankar Banerjee

-1

Magnus Mårtensson

Bhasker Das

-1

View all

Yesterday's leader

Shubhankar Banerjee

Blockchain, Solidity, Polygon, C#, NodeJS, HTML, C Language, C++, JavaScript, CSS, ReactJS, MySQL

Kanpur (India)

165

113.8k

11.3k

500

Member of the month

Mark Pelf

Belgrade (Yugoslavia)

188

283.7k

10.4k

500

Speaker of the month

Magnus Mårtensson

ASP.NET, .NET, C#, JavaScript, Azure

Sweden

17.2k

56.5k

Upcoming events

View all

Suggested for you

View all

Sanjay Kumar

Mamta M

Keyur Pandya

Atharva Urade

Vinodh Kumar

Forum Statistics

Please welcome our newest member luan .
3,075,564 users have contributed to 147,419 threads and 483,388
In the past 24 hours, we have 10 new threads, 28 new posts, and 200 new users.
In last week, the most popular thread is 'Query result in HTML format'.