fullpachaus

1. Objectdatasource Update Multiple Rows In Oracle

Objectdatasource Update Multiple Rows In Oracle

12 Flares Filament.io 12 FlaresIn this SQL tutorial,I will explain about How to update multiple rows in SQL Server with single SQL query? ENDAfter executing above query,you will get below message notified that all of your rows of table are updated.Now,you can see my all rows of ProductId 1,ProductId 2 & ProductId 5’s values are successfully changed.Check below image.Make sure that you don’t forget to write Else statement with your column name,otherwise it will insert NULL values for all other rows.Also you have to keep in mind that when you have large no. Of data in your table,you should not use this method,because it updates all rows which is quite costly.Check all If you have any problems,queries,don’t forget to comment below.