Updating multiple tables in sql server
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.