November 15, 2017 at 7:03 pm
great... now that correlation is stuck in my head too! it's spreading!
November 15, 2017 at 7:18 pm
Jason A. Long - Wednesday, November 15, 2017 4:33 PMIt's the same reason the Flash Gordon theme song pops into my head any time I see a Celko post...
great... now that correlation is stuck in my head too! it's spreading!
You'r welcome! 😀
November 15, 2017 at 11:35 pm
Jeff Moden - Wednesday, November 15, 2017 3:20 PMHeh... understood. 😉
Sorry... I never really matured, mentally, beyond the average 15 year old... It couldn't be helped...
When I wrote it, I wondered if anyone would understand the implication. 😉 Glad someone caught it.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 16, 2017 at 8:26 am
Flash a-ah
He'll save every one of us
November 16, 2017 at 1:11 pm
Steve Jones - SSC Editor - Thursday, November 16, 2017 8:26 AMFlash a-ah
He'll save every one of us
Yup... That's the one... Every single time...
November 17, 2017 at 7:34 am
Nice question, with correct answer.
Pity about the explanation, where the statement about delay to the end of the batch is pure nonsense. There's no delay, it operates imediately; all future conversions between string and data or vice versa will use the new language, not the old one. What doesn't happen is that all existing date variables are by magic changed to be different dates, and that (fortunately) doesn't happen at the end of the batch either, since values in databases can be changed only by commiting update or merge statements and values in variables are only modified by set variable statements.
Tom
Viewing 6 posts - 31 through 35 (of 35 total)
You must be logged in to reply to this topic. Login to reply