Updating multiple tables in sql server

by  |  18-Jan-2020 11:49

Can you do this type of statement when creating a view? I'll have to see if '71054' can be called as a parameter in VS 2003.

The SQL Server (Transact-SQL) UPDATE statement is used to update existing records in a table in a SQL Server database.

There are 3 syntaxes for the UPDATE statement depending on whether you are performing a traditional update or updating one table with data from another table.

to deal with it, i tried to delete the existing row in table A where the primary key matches for the updated row and then simply insert the row from the "inserted" table.

But, tsql simply does not let me delete me from a trigger and gives an error stating "The multi-part identifier "INSERTED.

So I can create a report that asks for the unit to be updated and then the value we are updating to.