TechTalkz.com Logo Ask the Experts!

Go Back   TechTalkz.com Technology & Computer Troubleshooting Forums > Tech Support Archives > Microsoft > Microsoft SQL Server

Formatting query/view in SQL Server Management Studio (2005)

Microsoft SQL Server

 
 
Thread Tools Display Modes
Unread 09-11-2007, 08:15 PM   #1
Paul
Guest
 
Posts: n/a
Formatting query/view in SQL Server Management Studio (2005)

This may be a stupid question but...

When designing a query or view, I write the SQL visually formatted the way I
like it. But when I run the query in Management Studio, the software
reformats the query into a mess (even though it still runs).

Is there an option or configuration which would allow me to keep the
formatting that I like?

Should I post this in another newsgroup?
 
Unread 09-11-2007, 09:10 PM   #2
Aaron Bertrand [SQL Server MVP]
Guest
 
Posts: n/a
Re: Formatting query/view in SQL Server Management Studio (2005)

Yes, use a query window (Ctrl + N), not the query designer?




"Paul" <Paul@discussions.microsoft.com> wrote in message
news:9563908A-1E74-4606-AEB8-7099BF9C6BB6@microsoft.com...
> This may be a stupid question but...
>
> When designing a query or view, I write the SQL visually formatted the way
> I
> like it. But when I run the query in Management Studio, the software
> reformats the query into a mess (even though it still runs).
>
> Is there an option or configuration which would allow me to keep the
> formatting that I like?
>
> Should I post this in another newsgroup?



 
 

Thread Tools
Display Modes



< Home - Windows Help - MS Office Help - Hardware Support >


New To Site? Need Help?

All times are GMT. The time now is 02:46 PM.


vBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO
Copyright © 2005-2013, TechTalkz.com. All Rights Reserved - Privacy Policy
Valid XHTML 1.0 Transitional