Conversion Fun

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by The Kid » Conversion Fun

26 posts, Page 2 of 3

««1 2 3 »»

Conversion Fun

Rate Topic

Display Mode

Topic Options

Author

Message

Brian LeBlanc-449582

Posted Wednesday, March 11, 2009 6:26 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 04, 2010 11:18 AM
Points: 547, Visits: 66

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

Brian RL: Be serious about your work, but do not take yourself too seriously {Philip A. Fisher}

Post #673159

webrunner

Posted Wednesday, March 11, 2009 8:10 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:05 PM
Points: 2,117, Visits: 2,209

Brian LeBlanc (3/11/2009)

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

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

-------------------
"The chemistry must be respected." - Walter White

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Post #673280

The Dixie Flatline

Posted Wednesday, March 11, 2009 8:32 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 2:02 PM
Points: 3,788, Visits: 5,543

Lucky you. I got the question wrong without even answering it.

ME TOO !! :P

Has anyone else applied the latest HotFix to sp_MSGoBackInTime ??

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? -- Stephen Stills

Post #673312

webrunner

Posted Wednesday, March 11, 2009 8:37 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:05 PM
Points: 2,117, Visits: 2,209

Bob Hovious (3/11/2009)

...

Has anyone else applied the latest HotFix to sp_MSGoBackInTime ??

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

-------------------
"The chemistry must be respected." - Walter White

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Post #673320

The Dixie Flatline

Posted Wednesday, March 11, 2009 8:43 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 2:02 PM
Points: 3,788, Visits: 5,543

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

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? -- Stephen Stills

Post #673331

Tom Garth

Posted Wednesday, March 11, 2009 9:06 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, February 04, 2011 7:20 AM
Points: 977, Visits: 1,499

Bob Hovious (2/19/2009)

Undocumented but useful: sp_MSGoBackInTime

It's no longer undocumented. Cool

Tom Garth
Vertical Solutions

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

Post #673360

The Dixie Flatline

Posted Wednesday, March 11, 2009 9:13 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 2:02 PM
Points: 3,788, Visits: 5,543

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

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? -- Stephen Stills

Post #673367

J-440512

Posted Wednesday, March 11, 2009 10:14 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, September 14, 2009 5:22 AM
Points: 438, Visits: 918

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.

Post #673435

The Dixie Flatline

Posted Wednesday, March 11, 2009 10:18 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 2:02 PM
Points: 3,788, Visits: 5,543

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.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? -- Stephen Stills

Post #673441

J-440512

Posted Wednesday, March 11, 2009 10:29 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, September 14, 2009 5:22 AM
Points: 438, Visits: 918

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.

Post #673460

« Prev Topic | Next Topic »

26 posts, Page 2 of 3

««1 2 3 »»

Permissions