SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by The Kid / Conversion Fun / Latest Posts

RE: Conversion Fun

J-440512 — Wed, 11 Mar 2009 14:22:37 GMT

[quote][b]Bob Hovious (3/11/2009)[/b][hr]As long as there is going to be carnage, would you also add to the victims' list the names of those who say "Choose your answer", instead of "Choose all you think are correct?" :P[/quote]Actually, more of a Darwin limitation (unfortunately void if they had time to reproduce)."Victims"? Hardly. Just a hit list.The President asked the CIE, the local police, and the FBR to find where whe wabbits live.The CIE consulted mineral and vegetal assets and concluded there was no such thing as a wabbit.The local police came back with a badly beaten bear which said OK, OK I'm a wabbit.The FBR torched all the forests it could find and said the wabbits had it comin'.It's been a long day today. I guess I am getting close to being reported.:ermm:

RE: Conversion Fun

J-440512 — Wed, 11 Mar 2009 14:12:47 GMT

Ach soooo ...How about next time YOU have to debug SQL statments embedded in the application code. The genius could not code it likeSELECT Customer_Name, Customer_Code, Customer_Alias FROM CustomerOf course not. Since the application supports it, this brilliant coding was used:q.Fields[2], Fields[14], Fields[21]...That genius I would have gladly strangled.A honest mistake, I can accept. Hey I am still learning today that I was wrong about things I was certain of. Plus, I am ashamed of code I wrote only a few years ago.But poison code guaranteed to make soemone else's life miserable, NEVER.And suppressing comments, that is also high on my 5hit list.As for escaping, "I haff detailed files".

RE: Conversion Fun

The Dixie Flatline — Wed, 11 Mar 2009 14:09:43 GMT

As long as there is going to be carnage, would you also add to the victims' list the names of those who say "Choose your answer", instead of "Choose all you think are correct?" :P

RE: Conversion Fun

JF1081 — Wed, 11 Mar 2009 14:04:23 GMT

Holy crap, the Code Gestapo is going to make his rounds!I am [b]removing all comments[/b] from any code that may point back to me. What do you think about that?

RE: Conversion Fun

J-440512 — Wed, 11 Mar 2009 10:36:38 GMT

Not good enough.I want the satisfaction.In fact, a knife would be even more personal.

RE: Conversion Fun

jcrawf02 — Wed, 11 Mar 2009 10:33:50 GMT

[quote][b]J (3/11/2009)[/b][hr]OKay ...Yes I did learn something here, about a star symbol being entered by an implicit conversion. All the more reason to condemn "tricks" like assigning an integer to a char or varchar that is not long enough.The post is OK, on the caveat that instructions be added that anyone producing code like this needs to be identified, taken in the street and shot. And his house burned down. Preemptive strike to avoid the grief of being stuck later when the guilty party is out of reach.[/quote][sarcasm] Think Green - if you're already going to burn down his house, save the bullet. Let's not be wasteful. Think of the street cleaners. [/sarcasm]

RE: Conversion Fun

J-440512 — Wed, 11 Mar 2009 10:29:14 GMT

OKay ...Yes I did learn something here, about a star symbol being entered by an implicit conversion. All the more reason to condemn "tricks" like assigning an integer to a char or varchar that is not long enough.The post is OK, on the caveat that instructions be added that anyone producing code like this needs to be identified, taken in the street and shot. And his house burned down. Preemptive strike to avoid the grief of being stuck later when the guilty party is out of reach.

RE: Conversion Fun

The Dixie Flatline — Wed, 11 Mar 2009 10:18:11 GMT

Some of the questions of the day wind up being just trivia, not suggested best practices. But sometimes you stumble across some code that needs fixing and knowing about these kinds of bizarre behaviours just might give you a clue.

RE: Conversion Fun

J-440512 — Wed, 11 Mar 2009 10:14:41 GMT

Is there like a point to any of this ?Unless there is a darn good reason I cannot fathom, this kind of programming is to be condemned.Especially since even a beginner objects to setting a char to something that is obviously not a character.

RE: Conversion Fun

The Dixie Flatline — Wed, 11 Mar 2009 09:13:19 GMT

I'm just waiting for it to be listed in BOL. ;)

RE: Conversion Fun

Tom Garth — Wed, 11 Mar 2009 09:06:52 GMT

[quote][b]Bob Hovious (2/19/2009)[/b][hr]Undocumented but useful: sp_MSGoBackInTime[/quote]It's no longer undocumented.:cool:

RE: Conversion Fun

The Dixie Flatline — Wed, 11 Mar 2009 08:43:23 GMT

Yeah that's what we had to do too. The cyborg got all bummed out about it and walked off muttering something about going into politics.:cool:

RE: Conversion Fun

webrunner — Wed, 11 Mar 2009 08:37:53 GMT

[quote][b]Bob Hovious (3/11/2009)[/b][hr]...Has anyone else applied the latest HotFix to sp_MSGoBackInTime ??[/quote]Yes, but after an awkward incident wherein Sarah Connor ran by me pursued by a mean-looking cyborg, I thought it was best to roll back the HotFix ASAP.Cheers,webrunner

RE: Conversion Fun

The Dixie Flatline — Wed, 11 Mar 2009 08:32:04 GMT

[quote]Lucky you. I got the question wrong without even answering it.[/quote]ME TOO !! :PHas anyone else applied the latest HotFix to sp_MSGoBackInTime ??

RE: Conversion Fun

webrunner — Wed, 11 Mar 2009 08:10:47 GMT

[quote][b]Brian LeBlanc (3/11/2009)[/b][hr]I got it right and didn't even answer it... I guess I answered it right tomorrow. :hehe:[/quote]Lucky you. I got the question wrong without even answering it. I took it as a sign that I should study my SQL better - and should do so in the present, not in the future. :) (Actually, I think I answered it wrong back on Feb. 12 when it popped up early....)Cheers,webrunner

RE: Conversion Fun

Brian LeBlanc-449582 — Wed, 11 Mar 2009 06:26:11 GMT

I got it right and didn't even answer it... I guess I answered it right tomorrow. :hehe:

RE: Conversion Fun

Ronald H — Wed, 11 Mar 2009 05:59:34 GMT

I feel like being in Back to the Future... "The time-traveling is just too dangerous. Better that I devote myself to study the other great mystery of the universe: women!" Well, or SQL Server of course :)

RE: Conversion Fun

jcrawf02 — Wed, 11 Mar 2009 05:32:48 GMT

[quote][b]SanjayAttray (2/12/2009)[/b][hr]This question is mentioned for March 11 and today is feb 12.[/quote]Now that's funny. Here it is March 11th, and it pops up again. sp_MSGoBackInTime really does work.

RE: Conversion Fun

INCREDIBLEmouse — Wed, 04 Mar 2009 06:03:52 GMT

Inexperienced person talking here, feel free to move to next topic. :)I got this one wrong as well. What threw me here is the fact that you assigned an integer value to the char. Now, to me, one would think that since you applied an int value to a char, it would just stop there and say something like "Are you stupid?". I assumed, that if it would magically convert the int value to string, and apply it, then it would truncate the string down to '1' automatically as well. If you had simply changed 10 to '10', the whole thing would have worked. It's because '10' would have worked that really made me fumble here.

RE: Conversion Fun

Max-146500 — Mon, 23 Feb 2009 17:29:12 GMT

Shamefull, I blisfully ignored the first clause in the case statement that determined it was a character data type, oh bother.

RE: Conversion Fun

The Dixie Flatline — Thu, 19 Feb 2009 08:49:06 GMT

Undocumented but useful: sp_MSGoBackInTime

RE: Conversion Fun

Kit G — Mon, 16 Feb 2009 09:02:55 GMT

Steve must have gotten his hands on a time machine. Or a TARDIS. If so, I wanna know where he got it cause I want one! :w00t:

RE: Conversion Fun

emanuel.unge — Fri, 13 Feb 2009 07:57:35 GMT

i have no idea what happened here

RE: Conversion Fun

JF1081 — Fri, 13 Feb 2009 07:44:14 GMT

Did I miss a month somewhere?

RE: Conversion Fun

SanjayAttray — Thu, 12 Feb 2009 13:40:50 GMT

This question is mentioned for March 11 and today is feb 12.

Conversion Fun

emanuel.unge — Thu, 12 Feb 2009 10:00:15 GMT

Comments posted to this topic are about the item [B]Conversion Fun[/B]