Viewing 15 posts - 76 through 90 (of 233 total)
Yes, a strange result. Try this:
DECLARE @tmp1 FLOAT = 0.289;
SELECT CONVERT(decimal(38,36),ROUND(@tmp1, 2)*100),
CONVERT(decimal(38,36),ROUND(@tmp1, 2))*100
Well, that's no more strange than any...
January 16, 2020 at 2:29 pm
Well, 29 would have been too easy, and the title of the QOTD hinted at the result not being quite the obvious. Casting to INT always truncates decimals, so it...
January 16, 2020 at 10:11 am
Good one!
The problem is that casting to int always removes any decimals, and with the example, 0.289 is actually stored as a value which, when converted with the maximum number...
January 16, 2020 at 8:49 am
Option 1 works only if you replace the {} with [] as follows:
df.columns = ['BillMonth', 'InvoiceAmount']
True, dat! So, we're down to the missing alternative of "None", I suppose...
December 18, 2019 at 9:06 pm
Option 1 may well work, but in this instance, it's renaming the wrong field so is wrong for the question posted.
(I know, I'm being really picky now).
I really don't...
December 18, 2019 at 11:56 am
Option one won't work as it's renaming the wrong field.
Option one should work, shouldn't it, since it sets the name of all the columns, but uses the old name...
December 18, 2019 at 11:37 am
I thought I wouldn't touch this question until it's been reviewed, but I couldn't resist.
Clearly, option 3 wouldn't work, since the original column name is "BillingAmount", and not "BillAmount". In...
December 18, 2019 at 8:30 am
I'll defer answering until Steve has sorted this one out.
November 27, 2019 at 10:43 am
Well, unfortunately, the documentation is a bit off. The bit about the session settings is correct, which matches what I wrote.
The bit about the database settings is incorrect. The correct...
November 25, 2019 at 9:34 am
Not to nit-pick, but the option is actually called ANSI_NULL_DFLT_OFF, so technically, all the answers are incorrect.
However, the database option is called ANSI_NULL_DEFAULT, which can be set to OFF or...
November 25, 2019 at 8:54 am
Looking at the available answers, the only logical response would be that it would fail, since all the other answers have both date and time that doesn't match the input...
September 27, 2019 at 8:28 am
Hush! That's probably for an upcoming QotD...
July 9, 2019 at 9:14 am
Interesting that arguments are optional until the're used in the function.
June 19, 2019 at 7:13 am
Evidently, I wrote much the same thing 4 years ago. 😛
June 17, 2019 at 7:18 am
I'm gonna go all "Four Yorkshire-men" on this and comment that back in my day, we'd been glad for ISQL/W. We would use SAF in character mode and be happy!...
June 17, 2019 at 7:16 am
Viewing 15 posts - 76 through 90 (of 233 total)