>Tabs don't appear the same way in text and GUI enviromnent so what looks great and all lined up in query analyzer is an undreadable mess in Access.
Yes I know a number of people who use Access ADPs to do stored proc development - the problem is it screws up any formatted SQL.
My suggestion is to move to Visual Studio.NET to do stored proc development.
>You don't need aliases when you create a query in a GUI environment, because it fully qualifies the names for you automatically, and I personally find it harder to read aliases than fully qualified names.
I agree
>The Answer? I beleive the answer lies in an automatic formatter - does anyone know of one? QUEST software has a fantastic tool for Oracle called Formatter Plus. I've asked them if they're doing one for SQL but they said not at this stage. Maybe if everyone can send them an email, they might get something happening.
I agree it would be nice to have a utility format all the stored procs in a database - we couldn't find a 3rd party util either, so we are currently adding to one of our SQL utilities (unless Brian Lockwood is adding it).
Email me (adamcogan@ssw.com.au) if you want to be told when we release it.
Adam