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
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • 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