Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

SSMS - dragging column names to query window doesn't add square brackets

If i drag a column (or list of columns) which have spaces from SSMS Object explorer to a query window, the column names are not qualified/quoted with square brackets meaning. This gives syntax errors when running queries. This is particularly frustrating when dragging a column set to a window as you have to manually add the square brackets to each column.

0 votes
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)

We’ll send you updates on this idea

AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...
  • KevinP commented  ·   ·  Flag as inappropriate

    Eyad, take a look at SQLTreeo SSMS Add-In. It uses DB metadata (or filesystem folders and files if you prefer) to create virtual folders in Object Explorer. It saved my scroll wheel finger from falling off. Virtual folders are bound to Object Explorer's existing folder structure (you can't place a View and a Procedure in the same virtual folder, for example), but it is easy to organize different object types into same-named virtual folders.

  • eyad al akhras commented  ·   ·  Flag as inappropriate

    If we could create folders in Object Explorer, and arrange database objects by drag/drop. This might be represented in a say "Business Root", rather than the current logical root and hierarchy.

Feedback and Knowledge Base