SQL – Agile BI http://agilebi.com A community for sharing ideas about business intelligence development using agile methods. Fri, 10 Jul 2009 02:15:00 +0000 en-US hourly 1 https://wordpress.org/?v=6.2.2 [Double Clicking Bracketed Text in SSMS] http://agilebi.com/blog/2009/07/10/double-clicking-bracketed-text-in-ssms/ Fri, 10 Jul 2009 02:15:00 +0000 http://7.9 Continue reading →]]> I’m a big fan of SQL Server Management Studio; it’s a really great tool with a tremendous amount of functionality.  Lately I’ve been working in the new 2008 version of SSMS and a few days ago I noticed some peculiar behavior: when you double click on text that is surrounded by brackets in an MDX query editor, only the text is selected, not the brackets; however, when you double click on text that is surrounded by brackets in a regular SQL query editor, the text and the brackets are selected – even if the text within the brackets contains spaces.  How interesting is that?! Below are a couple screenshots to illustrate what I’m talking about:

Selected text in an MDX editor:

Here you can see that I double clicked on the word “Adventure” and only the word “Adventure” is selected.

Selected text in a regular SQL editor:

Here you can see that I double clicked on the word “Test” (you’ll just have to trust me on this!) and the entire text within the brackets, including the brackets, is selected.

]]>