Add Column without referencing alias in Select
-
Added a column to a heavily used table (production of course
) . Forgot that I had a second table with same column name. Almost all the queries that joined those two tables broke.Guess why.
Server: Msg 209, Level 16, State 1, Line 1
Ambiguous column name 'ColumnName'.
-
Dooo .. that was supposed to go to "DBA Learning Experiences (Oops!) "
Sorry guys.
quote:
Added a column to a heavily used table (production of course
) . Forgot that I had a second table with same column name. Almost all the queries that joined those two tables broke.Guess why.
Server: Msg 209, Level 16, State 1, Line 1
Ambiguous column name 'ColumnName'.
-
I guess its "Forum Learning Experience" for me.
quote:
Added a column to a heavily used table (production of course) . Forgot that I had a second table with same column name. Almost all the queries that joined those two tables broke.Guess why.
Server: Msg 209, Level 16, State 1, Line 1
Ambiguous column name 'ColumnName'.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply