Incorrect syntax around '-'

Question

I am trying to run a request on another server and should specify it in the select statement, but the server name has a '-' in it, for example the server name. this leads to an error in the header. How can i fix this?

Answer 1

Use square brackets []around the server name:

select  * 
from    [server-name].[db-name].[schema-name].[table-name]