我通过ODBC 连接MS SQL Server Express 2012数据库.
我的查询:
Select * from openquery(test,'SELECT * FROM Versuchsanlage_DB WHERE value =27')
但是这个查询
Select * from openquery(test, 'SELECT * FROM Versuchsanlage_DB WHERE identifier = AGENT.OBJECTS.Versuchsanlage.Variable_1_Byte')
要么
Select * from openquery(test, 'SELECT * FROM Versuchsanlage_DB WHERE identifier = Variable_1_Byte')
不起作用.为什么?