June 22, 2018 at 12:05 am
Comments posted to this topic are about the item Arithmetic
June 22, 2018 at 5:57 am
Nice, easy question to end the week on, thanks Junior
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
June 22, 2018 at 6:58 am
So why is it that with all the Implicit conversions that SQL can do, something, that to me seems so simple, has never been made addressed ?
June 22, 2018 at 8:42 am
Thanks - tricky question for me, but I learned something.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 22, 2018 at 8:58 am
Budd - Friday, June 22, 2018 6:58 AMSo why is it that with all the Implicit conversions that SQL can do, something, that to me seems so simple, has never been made addressed ?
This has nothing to do with implicit conversions. This is assigning a value to a type larger that it allows. If this were a column, you should have to implicitly change the column definition, that's just a recipe for disaster.
June 22, 2018 at 10:26 am
webrunner - Friday, June 22, 2018 8:42 AMThanks - tricky question for me, but I learned something.- webrunner
Many times, what I learn from the QotD is to slow down and pay attention to the details. This question is a good example. I scanned it & didn't connect the details in the declaration and the assignment. I could blame the absence of caffeine in my system, but the real problem is my lack of attention to detail.
Thanks for the question, Junior.
June 23, 2018 at 11:11 am
What does the SSMS version have to do with the question.
I mean it is a good question, requiring attention to detail but the SSMS version is totally unrelated.
June 23, 2018 at 11:43 am
Ray Herring - Saturday, June 23, 2018 11:11 AMWhat does the SSMS version have to do with the question.I mean it is a good question, requiring attention to detail but the SSMS version is totally unrelated.
We see it all the time, magicians, politicians and IT consultants throwing in unrelated things
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy