|
to format SQL??? Really, does a large stored procedure have to be on as few lines as possible? I can't believe the author didn't just make it a single line and be done with. Oh, and as few spaces as possible.
Now I have to format it just so I can begin to get a to grips with why it isn't doing what it is supposed to be doing.
|
|
|
|
|
This tool[^] might get you started.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Thanks: have used that before and there are a couple of others.
However, not the point. I shouldn't have to do that to existing code. Messy, inconsiderate, lazy buggers. 
|
|
|
|
|
R. Giskard Reventlov wrote: Messy, inconsiderate, lazy buggers.
Are you sure you're in the right line of work? Then again, you'll encounter that in any profession.
Marc
|
|
|
|
|
Rubbish. Doesn't format it my way.
|
|
|
|
|
It really is quite a good, flexible tool, with many options.
If the online options aren't good enough for you, fork over a few $$ and buy the full version, which has even *more* options.
|
|
|
|
|
Youare
right I
alw ays f
orm a
t my
codewithsp a
c
e
s an d
n ewli
nes wh er
appropriat e:
)
|
|
|
|
|
Very good. 
|
|
|
|
|
Format SQL? You'll be asking 'em to sort Alphabetti Spaghetti next! 
|
|
|
|
|
This is what I use:[^]
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
|
When I was learning to program (a long, long time ago), I was told that untidy code always contained more errors that tidy, well laid out code. If the programmer was too lazy to lay the code out neatly, what else was he too lazy to do.
|
|
|
|
|
My experience shows that to be a universal truth. Every programmer I've ever met who wrote sloppily formatted code had sloppy logic as well. Unfortunately, the reverse is not true. Tidy code does not guarantee tidy logic.
In the terms our logician friends would use, tidy source code is a necessary but not sufficient condition to have tidy logic.
Software Zen: delete this;
|
|
|
|
|
My experience has been that people who write messy code, don't really understand it --- they mostly just copy'n'pasted it from somewhere, and then hacked at it until it (sorta) worked. It looks like a black box, because they view it as a black box: data goes in, magic happens, data comes out and no one knows why.
Recently, I attended a lecture on functional programming in C#. Most of the audience was rather quiet and I was the only one asking questions. One line of code was like this:
return b => a => a + b;
After a bit of prodding, I got him to rewrite it as:
return (b)=>
{
return (a) => { return a + b; }
}
And suddenly, the room came alive where finally everyone realized what the line was doing.
Truth,
James
|
|
|
|
|
And then he realized that you write code for people, not compilers. compilers don't care (in most cases) about format, but good format aid in the understanding of the code by others, and yourself when you have to debug or maintain it.
|
|
|
|
|
When I allowed Microsoft's SQL tools to re-interpret my code, they not only shoved it into as few lines as possible, but actually pulled apart the Boolean logic in moderately complex WHERE clauses and rewrote them with unnecessary repetitions of elements interspersed with extra AND's and/or OR's so that I couldn't even understand my own logic. Lots of guys like to use Microsoft's code generation tools, resulting in code like that, but they don't even try to look at the code, they just work from the code generation tool. So, maybe what you're seeing isn't even coded directly by a human. What I did is to take over the code, always formatted and saved it in a way that bypassed the code generation crap, and explained to the other developers how my code worked and why it was best to keep it formatted like I did, or they would never be able to understand and modify it.
|
|
|
|
|
I always format my SQL, because I maintain the master in .txt or .sql files. Unfortunately, many systems reformat it for you - SQL Server among them. Which is otherwise far better than Oracle or DB/2.
That is one of the things I detest about most IDEs (especially Visual Studio). They reformat my carefully formatted code.
|
|
|
|
|
I just downloaded this[^] which is free and integrates into VS and SSMS and appears to work pretty well.
You can configure VS/SSMS to do some basic formatting but I also keep everything as re-usable scripts stored in TFS.
|
|
|
|
|
...and it made me laugh, anyway: Copy The Reindeer[^]
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
But it says "copy", not "copy and paste"! 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Yeah, that really made me laugh too!
All they achieved was copying the empty grid on the right onto itself.
It's obvious that ctrl+c must be written into the left grid and ctrl+v must go into the right grid where it already is.
And that's the whole of the joke really. 
"I had the right to remain silent, but I didn't have the ability!"
Ron White, Comedian
|
|
|
|
|
Oh look, a VB programmer in the making!
Marc
|
|
|
|
|
I always thought the zenith of PETA's inanity was reached when the sent a letter to Ben and Jerry (the ice-cream guys) asking them to make ice-cream from human breast milk [^] ... but, now:
PETA is now suing photographer David Slater on behalf of the Macaque Monkey, Naruto, even though the U.S. Copyright Office has ruled that animals cannot have status as "authors." [^]. According to Slater, Naruto absconded with his camera, and took the picture "on his own" (sounds of snickering).
The legal remedy PETA seeks is: "the ability to license the monkey selfies (wait, there’s more than one?) and use the proceeds “solely for the benefit of Naruto, his community of crested macaques, and preservation of their habitat.”
One wonders if the infinitely-sensitive (what are they "on" ? I want some) minds of PETA will come up with something in the future like suing the U.N. for reparations for the trillions of earthworms used for bait.
I wish I could make-up stories like this one
«I want to stay as close to the edge as I can without going over. Out on the edge you see all kinds of things you can't see from the center» Kurt Vonnegut.
|
|
|
|
|
Even if Naruto could have status as the "author" of the "selfie", I can see no reasonable grounds under which PETA should have any access to his money... the Macaque himself, yes - there is some good justification there (sort-of), but a third party that have never been involved? Go forth and multiply...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
If the monkey wishes to persue this, he should take it up in court. PETA should stick to naked models.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
