Arithmetic

• Junior Galvão - MVP

  SSCertifiable

  Points: 6399

  June 22, 2018 at 12:05 am

  #352169

  Comments posted to this topic are about the item Arithmetic

• Stewart "Arturius" Campbell

  SSC Guru

  Points: 71393

  June 22, 2018 at 5:57 am

  #1994958

  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”

• Budd

  Hall of Fame

  Points: 3627

  June 22, 2018 at 6:58 am

  #1994962

  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 ?

• webrunner

  One Orange Chip

  Points: 29915

  June 22, 2018 at 8:42 am

  #1994980

  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 says Can I join you?
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

• Luis Cazares

  SSC Guru

  Points: 183562

  June 22, 2018 at 8:58 am

  #1994982

  Budd - Friday, June 22, 2018 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 ?

  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.

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• Kaye Cahs

  SSCarpal Tunnel

  Points: 4135

  June 22, 2018 at 10:26 am

  #1994989

  webrunner - Friday, June 22, 2018 8:42 AM

  Thanks - 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.

• Ray Herring

  SSCertifiable

  Points: 5304

  June 23, 2018 at 11:11 am

  #1995059

  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.

• Eirikur Eiriksson

  SSC Guru

  Points: 182349

  June 23, 2018 at 11:43 am

  #1995061

  Ray Herring - Saturday, June 23, 2018 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.

  We see it all the time, magicians, politicians and IT consultants throwing in unrelated things 😀
  😎