Quotes from heck and other format anomalies
How come if I type in code for a procedure, use 4-space indents and blank lines, that upon viewing the code in SQL Central the code is 2-space indented, the blank line is stripped out, and ALL identifiers are quoted (even though I told the editor to not quote identifiers)? There seems to be no way to create nice-looking, readable code. The code below was NOT the way it was typed in. Yes, the snippet was taken from a Toad screenshot, but SQL Central is similar.
SQL Anywhere 16
Message was edited by: Larry Molter
Jason Hinsperger replied
When the stored procedure is processed by the server it is parsed and then 'unparsed' into a format that is more 'correct' to the server. This removes most formatting and explains what you are seeing.
This typically isn't an issue because many (most?) development teams store their SQL as script files in their source control system and edit from there as opposed to from editing from the database definitions directly.
One final note. If you use Sybase Central to edit your stored procedures, it will preserve the formatting of the procedures for you.