sql-hunting-dog
sql-hunting-dog copied to clipboard
Missing brackets for SELECT from Table / View
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...