An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

Question

hi, any idea why I'm getting these sort of errors: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name. USE [$(DatabaseName)]; GO

Answer 1

Hi @han gao In what scenario did you encounter this error? I found the post you're getting an error on, not sure which one you're coming across. https://stackoverflow.com/questions/24998586/sql-server-query-erroring-with-an-object-or-column-name-is-missing-or-empty

https://blog.sqlauthority.com/2017/10/13/sql-server-msg-1038-object-column-name-missing-empty-select-statements-verify-column-name/ Best regards, Percy Tang