|
So, a complex query fails with
Quote: Msg 8152, Level 16, State 13, Line 1
String or binary data would be truncated.
Now, which column is it? Surely the engine knows which column it is and could add it to the error message?
We're gonna fix it soon, honest![^]
|
|
|
|
|
 
What do you get when you cross a joke with a rhetorical question?
|
|
|
|
|
Soon, very soon! 
|
|
|
|
|
Isn't that what varchar(MAX) is for?
|
|
|
|
|
NVARCHAR(MAX) is a good think, but has two disadvantages:
1. You can't control where the data stored, in-page or as BLOB
2. Every size is passed so you can't use it for 'sanity' check (where data can not be longer than n)
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
Kornfeld Eliyahu Peter wrote: BLOB
Don't you mean CLOB?
Whether I think I can, or think I can't, I am always bloody right!
|
|
|
|
|
I mean like BLOB - out of page...
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
If you are suffering from this 10 years - you may start using Profiler...it can help!
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
You can always switch to Oracle. You'll develop a whole new set of gripes. 
|
|
|
|
|
Been there, done that.
Dual - I mean, FFS!
|
|
|
|
|
I understand the reasoning behind the Dual table.
Instead of adding a load of exceptions with possible "features" to the parser, they've added a readonly dummy table.
My personal gripes revolve mostly around the fact that you have a different set of Types depending on whether you're doing pure SQL, procedures or packages.
|
|
|
|
|
Ha! I didn't expect that! Quite amusing though all the same.
"The whole idea that carbon dioxide is the main cause of the recent global warming is based on a guess that was proved false by empirical evidence during the 1990s." climate-models-go-cold
|
|
|
|
|
Munchies_Matt wrote: I didn't expect that!
Really?
|
|
|
|
|
No, I thought we were a better team than that, but apparently not.
"The whole idea that carbon dioxide is the main cause of the recent global warming is based on a guess that was proved false by empirical evidence during the 1990s." climate-models-go-cold
|
|
|
|
|
An Irishman walks into a bar in Dublin, orders three pints of Guinness and sits in the back of the room, drinking a sip out of each one in turn. When he finished all three, he comes back to the bar and orders three more.
The bartender says to him, ‘You know, a pint goes flat after I draw it; It would taste better if you bought one at a time.’ The Irishman replies, ‘Well, you see, I have two brothers. One is in America, the other in Australia, and I’m here in Dublin. When we all left home, we promised that we’d drink this way to remember the day we all drank together.’
The bartender admits that this is a nice custom, and leaves it there. The Irishman becomes a regular in the bar and always drinks the same way: he orders three pints and drinks the three pints by taking drinks from each of them in turn.
One day, he comes in and orders two pints. All the other regulars’ in the bar notice and fall silent. When he comes back to the bar for the second round, the bartender says, ‘I don’t want to intrude on your grief, but I wanted to offer my condolences on your great loss.’
The Irishman looks confused for a moment, then the light dawns in his eye and he laughs. ‘Oh, no,’ he says, ‘Everyone is fine. It’s me……..I’ve quit drinking!’
|
|
|
|
|
|
What the hell happened to England team? So disappointing 
|
|
|
|
|
No, they only booked the team hotel for the first week anyway... 
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
Disappointing maybe, it's your point of view, I bet the Uruguayans have a completely different view on the subject.
Unexpected? Not really.
|
|
|
|
|
What happened? They won?!
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
|
Once again the England team have gone and done the worst thing they possibly could have done - made me do basic arithmetic and probabilities!
|
|
|
|
|
same thing that happens pretty much every world cup
they get all excited, write lots of articles about how they're gunna win this time, put out a bunch of world cup songs - analyse the heck of of everything
and then lose.
oh well
Bryce
MCAD
---
|
|
|
|
|
England also talked about their golden generation a little while back, with players like Beckham, Gerrard, Lampard, Owen etc. It wasn't so golden after all and now, with no superstars, they play much a little bit better, but still loses in the end.
BTW: Congrats to Australia that scored the best goal so far 
|
|
|
|
|
Kenneth Haugland wrote: BTW: Congrats to Australia that scored the best goal so far |
but i'm a kiwi 
we were undefeated at the last world cup !
Bryce
MCAD
---
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
