The rest of the batch is not executed, and an error message is returned.
All other references to the object in the FROM clause must include an object alias. Table1 (c1 int PRIMARY KEY NOT NULL, c2 int NOT NULL); GO CREATE TABLE dbo. Table2 WHERE CURRENT OF abc; GO SELECT c1, c2 FROM dbo.
A view with an INSTEAD OF UPDATE trigger cannot be a target of an UPDATE with a FROM clause. Table2 (d1 int PRIMARY KEY NOT NULL, d2 int NOT NULL); GO INSERT INTO dbo. Table2 VALUES (1, 20), (2, 30); GO DECLARE abc CURSOR LOCAL FOR SELECT c1, c2 FROM dbo. Table1; GO Support for use of the READUNCOMMITTED and NOLOCK hints in the FROM clause that apply to the target table of an UPDATE or DELETE statement will be removed in a future version of SQL Server.
However, a large amount of data is more efficiently streamed into a file by using Win32 interfaces.
When you update a FILESTREAM field, you modify the underlying BLOB data in the file system.
Common table expressions can also be used with the SELECT, INSERT, DELETE, and CREATE VIEW statements.