Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Conversion Fun Expand / Collapse
Author
Message
Posted Wednesday, March 11, 2009 6:26 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 4, 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.

Brian RL: Be serious about your work, but do not take yourself too seriously {Philip A. Fisher}
Post #673159
Posted Wednesday, March 11, 2009 8:10 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 11:06 AM
Points: 2,331, Visits: 2,666
Brian LeBlanc (3/11/2009)
I got it right and didn't even answer it... I guess I answered it right tomorrow.


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


-------------------
"Operator! Give me the number for 911!" - Homer Simpson

"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
Posted Wednesday, March 11, 2009 8:32 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:33 PM
Points: 4,009, Visits: 6,072
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
Posted Wednesday, March 11, 2009 8:37 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 11:06 AM
Points: 2,331, Visits: 2,666
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


-------------------
"Operator! Give me the number for 911!" - Homer Simpson

"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
Posted Wednesday, March 11, 2009 8:43 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:33 PM
Points: 4,009, Visits: 6,072
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.



__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? -- Stephen Stills
Post #673331
Posted Wednesday, March 11, 2009 9:06 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, February 4, 2011 7:20 AM
Points: 977, Visits: 1,499
Bob Hovious (2/19/2009)
Undocumented but useful: sp_MSGoBackInTime


It's no longer undocumented.


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
Posted Wednesday, March 11, 2009 9:13 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:33 PM
Points: 4,009, Visits: 6,072
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
Posted Wednesday, March 11, 2009 10:14 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, July 14, 2014 12:33 PM
Points: 440, Visits: 929
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
Posted Wednesday, March 11, 2009 10:18 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:33 PM
Points: 4,009, Visits: 6,072
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
Posted Wednesday, March 11, 2009 10:29 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, July 14, 2014 12:33 PM
Points: 440, Visits: 929
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 »

Add to briefcase ««123»»

Permissions Expand / Collapse