Get Decimal/Float output from Integer Division in SQL Server - SQL Server Tutorial

Publicado el: 28 febrero 2015
en el canal de: TechBrothersIT

23,724

In this video we will learn how to get decimal/float output from Integer division in SQL Server.

I am creating this video to answer once of the question that I posted while back for TSQL Interview Question list

"If I run Select 100/11 what output will I get?"

When you divide Integer by an Integer in SQL Server, SQL Server returns Integer output.

As we can see from our above example, SQL Server output is Integer for Integers division. If we want to get float or Decimal output, Either our denominator or Numerator should be float or decimal type.
If we have both denominator or numerator as Integers, we can use convert or cast functions to convert one of them to float/decimal so we can get our results as float/decimal.

There are multiple techniques you can use to convert/cast to integer to float/decimal, here are some examples

SELECT CAST(100 AS FLOAT) /11 AS OutputResult
SELECT 100/CAST(11 AS FLOAT) AS OutputResult
SELECT 100/CAST(11 AS DECIMAL(12,0)) AS OutputResult
SELECT CAST(100 AS DECIMAL(12,0))/11 AS OutputResult

Blog post link with scripts used in the video
http://sqlage.blogspot.com/2015/02/ho...

En esta página del sitio puede ver el video en línea Get Decimal/Float output from Integer Division in SQL Server - SQL Server Tutorial de Duración hora minuto segunda en buena calidad , que subió el usuario TechBrothersIT 28 febrero 2015, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 23,724 veces y le gustó 71 a los espectadores. Disfruta viendo!