SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by SQL Buzz / Predict the outcome of the SQL statements / Latest Posts

RE: Predict the outcome of the SQL statements

Hardy21 — Tue, 09 Nov 2010 01:40:31 GMT

Nice question. Thanks

RE: Predict the outcome of the SQL statements

Koen Verbeeck — Wed, 03 Nov 2010 13:01:59 GMT

Good question, although it was more about convert than about ceiling.A link to the msdn page for convert and decimal:[url]http://msdn.microsoft.com/en-us/library/ms187928(SQL.90).aspx[/url] (convert)[url]http://msdn.microsoft.com/en-us/library/ms187746.aspx[/url] (decimal/numeric)The last page describes the gotcha of this question in the explanation of the scale.

RE: Predict the outcome of the SQL statements

SQLRNNR — Tue, 02 Nov 2010 14:26:06 GMT

Thanks for the question.

RE: Predict the outcome of the SQL statements

Cliff Jones — Tue, 02 Nov 2010 09:55:30 GMT

[quote][b]Tom.Thomson (11/2/2010)[/b][hr]Good question, but as some have already noted the explanation is a bit lacking.Also, the question was made too easy by the absence of the All 2s option as an answer choice - anyone who knows what ceiling means can eliminate all answers but the correct one with knowing anything at all about decimal or its default precision.[/quote]Yes, I agree. The best wrong answer was missing.

RE: Predict the outcome of the SQL statements

L' Eomot Inversé — Tue, 02 Nov 2010 07:38:04 GMT

Good question, but as some have already noted the explanation is a bit lacking.Also, the question was made too easy by the absence of the All 2s option as an answer choice - anyone who knows what ceiling means can eliminate all answers but the correct one with knowing anything at all about decimal or its default precision.

RE: Predict the outcome of the SQL statements

Toreador — Tue, 02 Nov 2010 07:06:35 GMT

I hope one thing that everybody has learned from these questions is that you should never rely on default precision for anything - you will inevitably get it wrong sooner or later :-)

RE: Predict the outcome of the SQL statements

John.Norcott — Tue, 02 Nov 2010 06:59:03 GMT

Thank you Old Hand. I knew the ceiling function brought you up to the next integer, but I couldn't figure out why the decimal was any different than the float on this one! You're explanation was what I was missing. For some reason I thought the default precision was 2, not 0. I'll be sure to remember that the next time I use a decimal data type.

RE: Predict the outcome of the SQL statements

Mike Is Here — Tue, 02 Nov 2010 06:39:50 GMT

Good question but I think a better explaination is:the default of decimal without parameters is (18,0) thus making 1.09 -> 1 and then the ceiling of 1 is 1

RE: Predict the outcome of the SQL statements

Toreador — Tue, 02 Nov 2010 03:35:38 GMT

Knew the answer but had a brain fart and clicked the wrong option, oops!UMG Developer is right about the explanation.

RE: Predict the outcome of the SQL statements

UMG Developer — Tue, 02 Nov 2010 00:16:25 GMT

Nice question, thanks! Though I think the explanation left a little to be desired. It isn't just that the decimal type was used, it was that the decimal type was used and no precision/scale was specified, so the number got rounded down to 1.0 when it was converted.For example this results in the same thing as all of your float examples:[code="sql"]select Ceiling(convert(decimal(2, 1), 1.09))[/code]Because with a scale of one specified it gets rounded to 1.1 before it goes to ceiling.

Predict the outcome of the SQL statements

bazzkar — Mon, 01 Nov 2010 22:24:20 GMT

Comments posted to this topic are about the item [B]Predict the outcome of the SQL statements[/B]