How can I format a query in SSMS so it does not look like this:
sELecT * fRoM CusTomERs
Currently SSMS doesn't have any tools to format queries except of query designer and Ctrl+Shift+U or Ctrl+Shift+L.|||I use promptsql.com for intellisense, which allow me to pick table and column names from a drop down. It integrates with SSMS and QA. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/> Currently SSMS doesn't have any tools to format queries except of query
> designer and Ctrl+Shift+U or Ctrl+Shift+L.
>|||
Somebdy wake me from this bad dream!
Yes I have tried promptsql. It is slow and does not format keywords, but is the only intellisense addon that works with SSMS. A much better product is SqlAssist but only works in Visual Studio. VS on the other hand is horrible for working with dbs, so I started cutting and pasting queries into SSMS.
Shame on Microsoft for all this marketting hoopla and they basically put out archaic software that is stuck in the 70s.
|||FWIW the latest release of PromptSQL will auto-uppercase keywords, and has new caching features which should make it faster.sql
No comments:
Post a Comment