Not all identifiers are quoted in generated SELECT statements

Issue #81 new
Former user created an issue

This is the SQL I get after right-clicking on a table and saying "Select Data":

-- Server : K12-R9-AL -- 

USE [EDDS1026079] 
GO 

SELECT TOP 200 
    [FileFieldArtifactID],
    [ArtifactViewFieldID]
FROM EDDSDBO.FileFieldArtifactViewField 
ORDER BY FileFieldArtifactID DESC,ArtifactViewFieldID DESC

If I had a table name or column named File, this would not work.

Compare to SSMS's native generation:

SELECT TOP 1000 [FileFieldArtifactID]
      ,[ArtifactViewFieldID]
  FROM [EDDS1026079].[EDDSDBO].[FileFieldArtifactViewField]

Comments (5)

  1. Log in to comment