Home Dashboard Directory Help
Search

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


Status: 

Active


21
2
Sign in
to vote
Type: Bug
ID: 544232
Opened: 3/24/2010 4:06:09 AM
Access Restriction: Public
0
Workaround(s)
view
5
User(s) can reproduce this bug

Description

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.
Details
Sign in to post a comment.
Posted by Microsoft on 5/17/2011 at 4:28 AM
Hello Rich,

There is a similar bug that we are tracking for this issue - http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=540306 . Given this, I am going to resolve your issue as duplicate of the other issue. In case you have any question or comments then contact me directly at nikhilku@microsoft.com

Thanks,
Nikhil Kumar
nikhilku@microsoft.com
Posted by Microsoft on 4/26/2011 at 12:00 PM
Hi Rich,

Thank you for sharing this feedback about the drag from OE feature in SSMS. This is just an update to let you know that we are tracking this as part of other issue 421541 which was filed earlier and is about a similar issue. 429116 will be closed as a duplicate of 421541. We will keep you posted about the status of 421541.

thank you

Seshagiri
Posted by Jamie Thomson on 3/24/2010 at 5:38 AM
Totally agree with this. Check this other related submission:

Improvements required for dragging columns from Object Explorer
(https://connect.microsoft.com/SQLServer/feedback/details/540306/ssms-improvements-required-for-dragging-columns-from-object-explorer)
Sign in to post a workaround.