|
Don't ask how but we ended up chatting about tongue twisters during lunch and I came out with the one below which my friend's mother taught us when we were teenagers. She got it wrong and started laughing and the more she laughed, the more wrong she got it! I was surprised that no one here had heard it before so here goes:
Note: SFW unless you get it wrong!
I'm not a pheasant plucker, I'm a pheasant plucker's mate. I'm only plucking pheasants 'cos the pheasant plucker's late
|
|
|
|
|
|
No Youtube link?
Anything that is unrelated to elephants is irrelephant Anonymous
- The problem with quotes on the internet is that you can never tell if they're genuine Winston Churchill, 1944
- I'd just like a chance to prove that money can't make me happy. Me, all the time
|
|
|
|
|
R. Giskard Reventlov wrote: I was surprised
Though it's hardly an obscure quote I'm not.
Peter Wasser
"The whole problem with the world is that fools and fanatics are always so certain of themselves, and wiser people so full of doubts." - Bertrand Russell
|
|
|
|
|
That was old when my father was a boy.
|
|
|
|
|
I bet there's a bad bat on the bed.
Not quite a tongue twister, but impossible to pronounce nonetheless.
Here's how an average Dutchie (including myself) would pronounce it: I BET there's a BET BET on the BET
|
|
|
|
|
So I gave her a grocery list in LINQ
var query_where1 = (
from item in Grocery.Store
where item.Price < 1.99
where item.Fresh == true
where item.Type.Contains("Produce")
select item).Take(5);
Which she really didn't care for; and I followed up with it in SQL
SELECT TOP 5 *
FROM Grocery.Store
WHERE Price < 1.99
AND Fresh = 1
AND Type = 'Produce'
I think she understands now
|
|
|
|
|
I know what you mean, I prefer to use the Linq methods as well - the Linq syntax is just a PITA to read.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
+1
|
|
|
|
|
Please forgive my lack of markdownability....
|
|
|
|
|
My girlfriend asked me why I cursed at LINQ and I told her to get in the kitchen and make me a sandwich.
|
|
|
|
|
But she had to do the shopping first so she could make the sandwich...
I didn't dare want to make her do UNION 's with the bakery and the cheese factory
|
|
|
|
|
I do wish SQL would allow multiple WHEREs in place of ANDs -- just to assist with developing queries I'm working on in SSMS and I want to experiment with various WHERE clauses.
|
|
|
|
|
I can see it both ways, when I'm in SSMS and playing with WHERE options I end up with
SELECT * FROM Table
WHERE
-- FirstName = 'Herman'
-- AND
LastName = 'Munster'
|
|
|
|
|
Right, so sometimes I wind up making
SELECT * FROM Table
WHERE 1=1
AND LastName = 'Munster'
just so I have flexibility while I experiment.
|
|
|
|
|
And how would you handle ORs?
|
|
|
|
|
In the water, of course...(stroke! stroke! stroke!....)
__________________
Lord, grant me the serenity to accept that there are some things I just can’t keep up with, the determination to keep up with the things I must keep up with, and the wisdom to find a good RSS feed from someone who keeps up with what I’d like to, but just don’t have the damn bandwidth to handle right now.
© 2009, Rex Hammock
modified 28-Apr-17 17:46pm.
|
|
|
|
|
I hardly ever need to. Sometimes a I need an IN, but rarely an OR. And I'm not saying remove AND and OR, just make any additional WHEREs act as ANDs.
|
|
|
|
|
When I'm testing out filters I'm usually starting with WHERE 1=1 and add all conditions with an AND.
But I can see what you're getting at.
<edit>Just as you answered to Madmyche</edit>
|
|
|
|
|
Don't take them for granted. Making them read code and all.
|
|
|
|
|
MadMyche wrote: I think she understands now
or:
(select bacon).take(all)
Marc
Latest Article - Merkle Trees
Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
Artificial intelligence is the only remedy for natural stupidity. - CDP1802
|
|
|
|
|
I would throw an Flavor Overflow Exception at pound #10 error
|
|
|
|
|
That's why it's called programming and not laymen language.
|
|
|
|
|
Girlfriend 1, MadMyche 0
Get ready to pay up.
Peter Wasser
"The whole problem with the world is that fools and fanatics are always so certain of themselves, and wiser people so full of doubts." - Bertrand Russell
|
|
|
|
|
Looks to me just a simple matter of different syntax. One does not appear to be any more succinct or easier to read than the other.
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles
|
|
|
|