Monday, January 30, 2012

Wrap text in Query Window

SQL Server 2005/2008: How to wrap text in query window?

If you want to generate and edit a query that is very long in the Query window then it is easier if the generate query has next line characters. Otherwise you will end up with one long line and have to manually enter the next line characters. This can be painful if the query is very large and creates opportunities to make mistakes.

To enable text wrap go to Menu options TOOLS and then OPTIONS

Tools > Options > Text Editor

Enable the Wrap text option for 'ALL LANGUAGES'

You can also enable the options to display LINE NUMBERS in the same window.

No comments:

Post a Comment