Hightlighted text between single quotes on the Edit Table function does not work by Crakdkorn

Closed

Type:	Bug
ID:	779090
Opened:	2/12/2013 5:35:23 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

Cannot select a word (hightlight) between single quotes in SQL Server SSMS 2012 when in Edit Mode (as in right click table in the Object Explorer | Edit TOP 200 Rows - then click the SQL button on the toolbar to enter your where clause) If you set a WHERE condition into your edit statement and surround it by single quotes (no Red Gate or third party tools availabe which may correct the problem), the selection will not go to the word but instead to the right single quote in the expression. As in
SELECT A, B, C From SomeTable WHERE A='Alpha'
The double click to the word "ALPHA" will highlight the second single quote.

Details (expand)

English

SQL Server 2012 - Enterprise Edition

SQL Engine

Windows Server 2008 R2 Enterprise (SP1)

US English

Open a table using the "Edit Table" (highlight the table and right click the table name). Select the SQL view of the table. Add a where clause that searches for a text item found in a column.

SELECT A, B, C From SomeTable WHERE A='Alpha'
The double click to the word 'ALPHA' will highlight the second single quote.

The second single quote in the text expression (as above 'Alpha') will be highlighted.

The word ALPHA should highlight.

X64

Hyper-V (On-Premise)

File Name	Submitted By	Submitted On	File Size
229583[1].jpg	Crakdkorn	3/9/2013	55 KB
Toth.JPG	Crakdkorn	3/9/2013	19 KB
Toth.JPG	Crakdkorn	3/9/2013	19 KB
229583[1].jpg	Crakdkorn	3/9/2013	55 KB
Toth.JPG	Crakdkorn	3/9/2013	19 KB

Posted by Microsoft on 4/11/2013 at 10:16 AM

Hello Crakdkorn. Thanks for the feedback. We triaged this issue and at this time do not plan to address this in a future version of SQL Server. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)

Posted by Microsoft on 3/7/2013 at 10:03 AM

Hello Crakdkorn. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)

Microsoft