Solve object or column name is missing or empty errors

An object or column name is missing or empty. How to solve

3.1.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. Add a name or single space as the alias name.
This error comes during Execution of Sql-server queries.
it shows that there is error in query like double "" ''fieldname '' sometimes it need like 'fieldname'
only single ' or somewhere opening and closing parenthesis.
3.2.Incorrect syntax near ','

Msg 102, Level 15, State 1, Line 18
Just click on error line and check syntax

3.3The query uses non-ANSI outer join operators ("*=" or "=*"). To run this query without modification, please set the compatibility level for current database to 80 or lower, using stored procedure sp_dbcmptlevel. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes.

0 comments:

Post a Comment