|
Roger Wright wrote: What would be really useful is a cheap utility to locate exact duplicates of files, and allow you to select which ones to delete
write one you muppet
B
MCAD
---
|
|
|
|
|
Gads, how I'd love to have the time and energy to write real code again. Maybe when I win the Lottery tomorrow night...
Will Rogers never met me.
|
|
|
|
|
|
Lacks realism.
I mean, only 38?
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
Why, after all these years, is there still no standard for basic features of SQL. For example, the syntax for returning only [n] rows.
Top vs Limit[^]
This sort of stuff drives me nuts, as it requires a call out to the specific DB interface to properly generate the SQL for specific DB provider. Argh.
And if you want to do something more complex, like offsets and limits, this[^] is a fun read illustrating the syntax differences.
Marc
|
|
|
|
|
A desire for lock-in: vendor $$$
According to my calculations, I should be able to retire about 5 years after I die.
|
|
|
|
|
As said, vendor lock in. It was the same thing (sorta still is a bit) with the web for years. Everyone wants you to think "their way" is the best way.
Jeremy Falcon
|
|
|
|
|
Jeremy Falcon wrote: Everyone wants you to think "their way" is the best way.
When we all know, my way is the only way.
Michael Martin
Australia
"I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So I had to leave the place as soon as possible."
- Mr.Prakash One Fine Saturday. 24/04/2004
|
|
|
|
|
Michael Martin wrote: When we all know, my way is the only way.
there is always, "the highway".
|
|
|
|
|
LIMIT does make paging super easy. I know it's easier to do in SQL Server these days, but with LIMIT it's as easy as this:
SELECT * FROM mytable LIMIT 50, 50;
Assuming you're showing 50 records per page and currently viewing the second page.
Jeremy Falcon
|
|
|
|
|
Personally, I'd rather dump SQL completely, and go for a binary interface that doesn't let idiots leave themselves wide open to SQL Injection - but that's just crazy talk!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
OriginalGriff wrote: but that's just crazy talk
You're thinking way too progressive man. Might one wanna take time to cherish the old archaic way. This way we don't have to learn new concepts.
Jeremy Falcon
|
|
|
|
|
writing code that writes code which gets interpreted at runtime in a black box is the modern way.
|
|
|
|
|
I am sooooo tempted to have that as a sig!  
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
It'll never fly, Orville.
|
|
|
|
|
It's standardized since ISO SQL:2008 as the "FETCH FIRST" clause
And it's starting to get support too, it's at the moment supported by atleast IBM DB2, PostgreSQL, Microsoft SQL Server 2012 and Oracle 12c.
Wrong is evil and must be defeated. - Jeff Ello
Any organization is like a tree full of monkeys. The monkeys on top look down and see a tree full of smiling faces. The monkeys on the bottom look up and see nothing but assholes.
|
|
|
|
|
Jörgen Andersson wrote: "FETCH FIRST"
Isn't that only for cursors? Got a link to documentation?
|
|
|
|
|
Here[^]
Wrong is evil and must be defeated. - Jeff Ello
Any organization is like a tree full of monkeys. The monkeys on top look down and see a tree full of smiling faces. The monkeys on the bottom look up and see nothing but assholes.
|
|
|
|
|
Learn something new everyday... 
|
|
|
|
|
Sad is the day when you don't.
Wrong is evil and must be defeated. - Jeff Ello
Any organization is like a tree full of monkeys. The monkeys on top look down and see a tree full of smiling faces. The monkeys on the bottom look up and see nothing but assholes.
|
|
|
|
|
Naturally, MS messed up again by putting it together with the ORDER BY clause
Wrong is evil and must be defeated. - Jeff Ello
Any organization is like a tree full of monkeys. The monkeys on top look down and see a tree full of smiling faces. The monkeys on the bottom look up and see nothing but assholes.
|
|
|
|
|
I think the usage of TOP should be extended to include a SKIRT keyword to provide the OFFSET functionality.
|
|
|
|
|
And don't forget the REMOVE clause.
Wrong is evil and must be defeated. - Jeff Ello
Any organization is like a tree full of monkeys. The monkeys on top look down and see a tree full of smiling faces. The monkeys on the bottom look up and see nothing but assholes.
|
|
|
|
|
That's applicable to the Basic Relational Architecture.
|
|
|
|
|
As is the Lookup Table
Wrong is evil and must be defeated. - Jeff Ello
Any organization is like a tree full of monkeys. The monkeys on top look down and see a tree full of smiling faces. The monkeys on the bottom look up and see nothing but assholes.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
