SQL query with object name having illegal character

Question

I want to copy data from SQL Server A to SQL Server B; so I have query statement like:

INSERT INTO ServerA_Name.db_name.table_name 
SELECT * FROM ServerB_Name.db_name.table_name where date >= GETDATE()

However the ServerA' name has a illegal character: '-' (ex: A-01) and I can't change the ServerA' name since it would cause other potential problem. So I got the: Incorrect syntax near '-'. error.... Is there a good way to solve this issue?

Put the table or column name is square brackets. But I don't see dash being used anywhere in your query. — Tim Biegeleisen
– Tim Biegeleisen, Commented Jan 17, 2018 at 0:48
hi jones321, you may want to read this answer first, it may be a good reference. — Bagus Tesa
– Bagus Tesa, Commented Jan 17, 2018 at 0:48
Possible duplicate of can I give SQL Server database name with hyphen like abc-123? — Rajat Mishra
– Rajat Mishra, Commented Jan 17, 2018 at 0:50

JJWillMC · Accepted Answer · 2018-01-17 01:38:49Z

2

If Server A's name contained an illegal character (which I don't see one here in your case) you would need to place that server's name into square brackets, such as:

INSERT INTO [ServerA_Name].db_name.table_name

Square brackets in SQL server act as quotes and allow you to use special (or illegal) characters or spaces.

answered Jan 17, 2018 at 1:38

JJWillMC

1231 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL query with object name having illegal character

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related