Why i am getting error while queries in mssql like select * from DBname.dbo.tablename?

Question

Here AS is dbname and dbo is schema and MULTIPLE_SUBSCRIBERS is a table.

Error as follows:

Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'AS'.

Kindly help.

Error as follows:Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'AS'. — Venkatesh K, Mar 20 '18 at 07:45

score 2 · Accepted Answer · answered Mar 20 '18 at 08:18

2

AS is a keyword. The way you added it to the sql statement tells SQL Server to interpret it as such.

To use the database name AS, you need to use the following:

SELECT * FROM [AS].dbo.MULTIPLE_SUBSCRIBERS;

When using square bracket, SQL Server will always interpret the text as a name. This also works for names with spaces. For more see: What is the use of the square brackets [] in sql statements?

answered Mar 20 '18 at 08:18

rollstuhlfahrer

Thanks you so much rollstuhlfahrer. Its working fine after adding above characters. – Venkatesh K Mar 20 '18 at 09:55

1 Answers1