Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Wrap Text In Query Analyzer

Posted on 2004-10-14
4
477 Views
Last Modified: 2008-03-03
I'm trying to edit a long Select query, but most of it is on one very long line. How can I get the text to wrap?

Also, couldn't find a graphical design tool in Query Analyzer - just want to confirm that this is only available in Enterprise Manager.

Thanks!

0
Comment
Question by:tomfolinsbee
  • 2
4 Comments
 

Author Comment

by:tomfolinsbee
ID: 12314951
Should also mention that this is an update query and the text string is very long.
0
 
LVL 15

Accepted Solution

by:
jdlambert1 earned 125 total points
ID: 12314953
You have to manually wrap the text in QA, and the GUI's on in EM.
0
 
LVL 8

Expert Comment

by:SashP
ID: 12314954
Is there any reason you do not want to use carriage returns in your query?

It does not need to be all one one line.

Cheers Sash
0
 
LVL 8

Expert Comment

by:SashP
ID: 12314960
The graphical query builder is only available in enterprise manager.

0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question