This seems even a bit more complicated. For example:

- compatibility level = 120

- original datetime = '20210701 12:30:45.126'

- implicit conversion I get back = '2021-07-01 12:30:45.1270000'

I did a little research and it seems like this effect is in part related to the change in SSMS to using the Visual Studio shell, as mentioned in this...

This is what I used to compare @SomeVar is the original from Steve's post, and @SomeVar2 is what I hand type (direct copy paste).
DECLARE @SomeVar VARCHAR(2000)  = 'Wolfe­schlegel­stein­hausen­berger­dorff­welche­vor­altern­waren­gewissen­haft­schafers­wessen­schafe­waren­wohl­gepflege­und­sorg'
DECLARE...

I have been reading this blog for the past 7 years and this is the first one that has prompted my to post. Can someone explain please what is going...