You are viewing a single comment's thread. Return to all comments →
Apparently MS SQL rounds automatically in some cases:
"By default, SQL Server uses rounding when converting a number to a decimal or numeric value with a lower precision and scale" (link to docs)
Therefore for this query ROUND() isn't actually required.
SELECT CAST(SUM(LAT_N) AS DECIMAL(7,2)), CAST(SUM(LONG_W) AS DECIMAL(7,2)) FROM STATION
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 2
You are viewing a single comment's thread. Return to all comments →
Apparently MS SQL rounds automatically in some cases:
Therefore for this query ROUND() isn't actually required.