BUG: Original table name is offered in UPDATE alias
Alza
Posts: 4 Bronze 2
in SQL Prompt
Original (non-aliased) fields are listed in Prompt when using UPDATE alias FROM table AS alias.
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
Tagged:
Comments
Sorry for the inconvenience. I've reported this issue as SP-6593.
Best regards,
Krzysztof