Viewing 4 posts - 1 through 4 (of 4 total)
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'
September 29, 2021 at 3:20 pm
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...
October 15, 2018 at 10:09 am
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) = 'Wolfeschlegelsteinhausenbergerdorffwelchevoralternwarengewissenhaftschaferswessenschafewarenwohlgepflegeundsorg'
DECLARE...
October 15, 2018 at 9:42 am
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...
October 15, 2018 at 9:04 am
Viewing 4 posts - 1 through 4 (of 4 total)