|
Seeing as we're all dwelling on the negative today ...
Why is it that when I type this in SMS:
CAST (NULL AS BIGINT)
Unintellisense changes it to this:
CAST (NULL AS bigint)
I like my keywords in upper case!
Whenever you find yourself on the side of the majority, it is time to pause and reflect. - Mark Twain
modified 28-Aug-18 7:29am.
|
|
|
|
|
PeejayAdams wrote: Why is it that when I type this in SMS:
Be happy that it only changes the case... the auto corrector for SMS's could be funnier than that   
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Well, yes, it could be worse.
I once tested an SQL beautifier (name with-held to protect the guilty, but it was Apex) and while it made some extremely messy code look very nice it did render it unrunnable in the process.
What annoys me about SMS though, is the way that it's progressed from no Intellisense at all to "Hi!, I'm Clippy - it looks like you're trying to query a database!"
I can see how the whole thing's a much larger challenge for SQL than it is for a more structured language like C# but where the VS Intellisense is a wonderful thing, the SMS incarnation kind of isn't.
Anyway, mustn't spend all day moaning about it - I've got to refresh my local cache yet again ...
Whenever you find yourself on the side of the majority, it is time to pause and reflect. - Mark Twain
|
|
|
|
|
That thing in SMS is everything but intelligent...
A case sensitive search in a case-insensitive environment!!!
(there is a long - 8 years? - ignored report about it at Microsoft)
"The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge". Stephen Hawking, 1942- 2018
|
|
|
|
|
Well, yes, it's not like it worries about case elsewhere. You can write everything lower, everything upper or a mix of the two and it generally doesn't bat an eyelid but as soon as you're inside the brackets of a function call it goes bananas.
I can't see how removing a bit of bad code is taking 8 years.
Whenever you find yourself on the side of the majority, it is time to pause and reflect. - Mark Twain
|
|
|
|
|
First have to come the acknowledgment...
"The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge". Stephen Hawking, 1942- 2018
|
|
|
|
|
PeejayAdams wrote: Why is it
Because you choose the suggestion from AutoComplete and the suggestion is in lowercase. Simple solution, don't choose the suggestion.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
Not the case - it effectively auto-selects. It is a bug, pure and simple.
Whenever you find yourself on the side of the majority, it is time to pause and reflect. - Mark Twain
|
|
|
|
|
PeejayAdams wrote: Not the case - it effectively auto-selects
Actually no. It does not do it for me. If you hit TAB, for example, then it will. But if you type it out in full and don't select the suggestion, it won't change it.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
How odd! On mine, I simply type the word and it changes as soon as I hit the end of it - it looks like the (case insensitive) matching against the auto-complete option gets to the end and it says "Ah! that's the one, I'll replace the text".
I'm on v17.6
Whenever you find yourself on the side of the majority, it is time to pause and reflect. - Mark Twain
|
|
|
|
|
Maybe you have a third party intellisense installed?
And to be clear, I type BIGINT and either then hit SPACE or ) and it stays in CAPS. But if I hit TAB, it lower cases it.
I have SQL 17.8.1 But I'm pretty sure it's always been this way for me. Maybe there is an option. Don't know.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
It must be an option somewhere, mine's a vanilla installation but I don't even get as far as typing the closing bracket before it changes it.
Whenever you find yourself on the side of the majority, it is time to pause and reflect. - Mark Twain
|
|
|
|
|
Wasn't a great Hitchhikers book! 
|
|
|
|
|
I actually love fresh figs, but today we apparently only post complaints in the Lounge. Here we go:
You can't take a bite without crunching on a mouthful of seeds. And they are so sweet and make your fingers sticky when you try to eat them!
The real question now is: How should you actually eat them? Peel them and risk sticky fingers? I have heard that you can (should?) eat them with the peel. Not such a great idea if they have been treated with insecticides. And they are full of seeds!
I have lived with several Zen masters - all of them were cats.
His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
|
|
|
|
|
CodeWraith wrote: How should you actually eat them?
Roasted with honey and Ricotta, maybe some pistachios as well.
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Not at work, but maybe they still have some in the store when I'm done here today.
I have lived with several Zen masters - all of them were cats.
His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
|
|
|
|
|
THat isnt a million miles from a recipe I concocted:
Cut triangles of bric pastry (the north african stuff, a bit like thick filo), toast them.
Layer up sliced goats cheese, a triangle of pastry, slice of fig, ground pistacio nut, homey, sprinkle of herbes de provence, and repeat.
When its about 6 layers, about 3 inches high, stick a tooth pick through it all to hold it together and oven bake for 10 mins.
Serve it up on lettuce with a simple dressing.
It is an amazing dish. Incredible flavour and texture.
|
|
|
|
|
|
You probably would sooner get away with asking programming questions here than with this:
Quote: Traditionally with creme fraiche, onions and bacon. But very suitable to make the vegetarian way, like I did for this recipe.
Replacing bacon with anything sets you up for a s-storm here.
I have lived with several Zen masters - all of them were cats.
His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
|
|
|
|
|
CodeWraith wrote: Replacing bacon with anything sets you up for a s-storm here.
No, you can replace it with more bacon - that's OK.
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
OriginalGriff wrote: you can replace it with more bacon
BaconOverflowException: Endless recursion
I have lived with several Zen masters - all of them were cats.
His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
|
|
|
|
|
Bacon does not overflow: there is no limit to how much bacon you can add!
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Yes, there is!
The total plant mass on the planet is limited by the amount of radiation that the planet receives from the Sun.
The total animal mass on the planet (humans included), cannot be greater than a fraction of the total plant mass on the planet.
The total mass of pigs on the planet is a small fraction of the total animal mass.
(I trust that you're not counting on PIGS IN SPACE )
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
CodeWraith wrote: BaconOverflowException: Endless recur of discusion
FTFY
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
RickZeeland wrote: Flammkuchen with figs
"A sweet touch of fresh figs and honey, the slightly roasted crunchy hazelnuts, the fresh but slightly strong taste of red onion and goat cheese and the always delicious fresh thyme"
Right, so not a tarte flambée at all, a goats cheese onion and fig pizza.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
