主页 / server / 问题 / 995949
Accepted
Izzy
Asked: 2019-12-18 14:15:42 +0800 CST

SSMS Designer 删除方括号

  • 772

我正在设计一个访问链接服务器中的表的视图。

每次我将此查询粘贴到 SQL 窗格中时，Intellisense 都会删除方括号，然后抱怨有超过 3 个前缀。我试过关闭 Intellisense，但它一直在发生：

SELECT   Loc.Address1, Loc.Address2, Loc.Address3, BP.BusinessPartnerName
FROM     [REPORTING.SOMESERVER.CA].Toast.dbo.BusinessPartnerLocations AS Loc LEFT OUTER JOIN
         [REPORTING.SOMESERVER.CA].Toast.dbo.BusinessPartner AS BP ON Loc.BusinessPartnerID = BP.BusinessPartnerID

对此：

SELECT   Loc.Address1, Loc.Address2, Loc.Address3, BP.BusinessPartnerName
FROM     REPORTING.SOMESERVER.CA.Toast.dbo.BusinessPartnerLocations AS Loc LEFT OUTER JOIN
         REPORTING.SOMESERVER.CA.Toast.dbo.BusinessPartner AS BP ON Loc.BusinessPartnerID = BP.BusinessPartnerID

错误信息

sql-server

1 个回答

  1. Best Answer

    似乎将服务器名称封装在引号中会使 Intellisense 忽略它。

    FROM        ["REPORTING.SOMESERVER.CA"].Toast.dbo.BusinessPartnerLocations AS Loc LEFT OUTER JOIN
    • 1

相关问题