RE: Auto Format Query

[allyne]

Hello,

Is there a setting in Management studio that I can set that would auto format/corect my query syntax? For example if I type select * from table_name. What I really want is it to auto correct to make the query look like SELECT * FROM table_name

Thanks for your help!

 

[allyne]

Sorry...forgot to let you know that its on sql 2008 r2

 

[gk53]

select * from table_name and SELECT * FROM table_name the same query You can use IntelliSense if it is enabled on your Management studio which will give you big help with creating query and use drag and drop future from object explorer panel to main panel, but you should remember object explorer read database infor from cash and it is refershed only when you close and reopen management studio.

 

[djj55]

I believe there are third party add ons that will do what you wish. I also like to see code formated in a given way, but I manually do it with <CTRL><Shift>U for uppper case.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[allyne]

Great! Thanks for the Info!