Updating multiple rows at a time in sql

The Car Data table contains all the detailed car data like speed and position etc. There can be multiple trips for each car with each trip having a start and stop time.

In order to update a row in a SQL Server table you will use the UDPATE statement.

In this article I will show you a number of different ways to use the UPDATE statement to modify the data in your SQL Server tables.

There are multiple ways to use the UPDATE statement to update a SQL Server table.

Table-valued parameters can be passed as read-only input parameters.

Because transaction logs are not recorded for table-valued parameters, performance improves.

73

Leave a Reply