sql-hunting-dog icon indicating copy to clipboard operation
sql-hunting-dog copied to clipboard

Missing brackets for SELECT from Table / View

Open pklejnowski opened this issue 6 years ago • 9 comments

I noticed that there is missing brackets when you're trying to select some table or view. So it might be problematic when you have tables like: dbo.User

I don't know how to create PR so here is how to fix: File: ManagmentStudioController.cs Line: 74: builder.AppendFormat("\tSELECT TOP {0} {1}\r\n\tFROM [{2}].[{3}] {4}", selectTopX, selectColumns, view.Schema, view.Name, noLockHint); Line 105: builder.AppendFormat("\tSELECT TOP {0} {1}\r\n\tFROM [{2}].[{3}] {4}", selectTopXTable, selectColumns, tbl.Schema, tbl.Name, noLockHint);

Or can anyone tell me how to compile it to the install file? I'd like it to use it...

pklejnowski avatar Jun 20 '18 14:06 pklejnowski