All other references to the object in the FROM clause must include an object alias.
A view with an INSTEAD OF UPDATE trigger cannot be a target of an UPDATE with a FROM clause.
Table1', ' U') IS NOT NULL DROP TABLE dbo. Table2', ' U') IS NOT NULL DROP TABLE dbo. Table1 (Col A int NOT NULL, Col B decimal(10,3) NOT NULL); GO CREATE TABLE dbo. If the UPDATE statement could change more than one row while updating both the clustering key and one or more text, ntext, or image columns, the partial update to these columns is executed as a full replacement of the values.
Table2 (Col A int PRIMARY KEY NOT NULL, Col B decimal(10,3) NOT NULL); GO INSERT INTO dbo. Important The ntext, text, and image data types will be removed in a future version of Microsoft SQL Server.
Table1 VALUES(1, 10.0), (1, 20.0); INSERT INTO dbo. Avoid using these data types in new development work, and plan to modify applications that currently use them.