Original (non-aliased) fields are listed in Prompt when using UPDATE alias FROM table AS alias.
DECLARE @Table TABLE
(
Field INT
);
UPDATE
T
SET
T.Field = $CURSOR$
FROM
@Table AS T;
You can't use non-aliased @Table name, but Prompt is still suggesting it:
Latest SQL Prompt 8.x, but bug was introduces somewhere in 7.x
DECLARE @Table TABLE ( Field INT ); UPDATE T SET T.Field = $CURSOR$ FROM @Table AS T;You can't use non-aliased @Table name, but Prompt is still suggesting it:
Latest SQL Prompt 8.x, but bug was introduces somewhere in 7.x