-
assigned issue to
Not all identifiers are quoted in generated SELECT statements
Issue #81
new
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)
-
-
- changed milestone to 2016-02-01
-
- changed version to 3.5.0
-
- changed version to 3.6.0
-
- changed component to core
- Log in to comment