Intellisense with Bracketed Column Names
Posted: Fri 29 Jul 2016 12:23
Hello,
When writing a SQL statement like:
SELECT
c.CLIENT_ID,
c.CLIENT_NAME
FROM
dbo.CLIENT c;
if a new column is added below the CLIENT_NAME using brackets, then selecting the column in the intellisense list:
SELECT
c.CLIENT_ID,
c.CLIENT_NAME,
c.[CLIENT_ACTIVE]
FROM
dbo.CLIENT c;
Selecting from the intellisense list removes the lines below and ends up looking like:
SELECT
c.CLIENT_ID,
c.CLIENT_NAME,
c.[CLIENT_ACTIVE]
Is this a known issue?
Note: This only happens with multiline queries.
Info:
Microsoft SQL Server Management Studio 13.0.15600.2
SQL Complete Standard Edition 5.5.145
OS - Windows 10
Thanks.
When writing a SQL statement like:
SELECT
c.CLIENT_ID,
c.CLIENT_NAME
FROM
dbo.CLIENT c;
if a new column is added below the CLIENT_NAME using brackets, then selecting the column in the intellisense list:
SELECT
c.CLIENT_ID,
c.CLIENT_NAME,
c.[CLIENT_ACTIVE]
FROM
dbo.CLIENT c;
Selecting from the intellisense list removes the lines below and ends up looking like:
SELECT
c.CLIENT_ID,
c.CLIENT_NAME,
c.[CLIENT_ACTIVE]
Is this a known issue?
Note: This only happens with multiline queries.
Info:
Microsoft SQL Server Management Studio 13.0.15600.2
SQL Complete Standard Edition 5.5.145
OS - Windows 10
Thanks.