SQL Server/T-SQL/Data Type/float

Материал из SQL эксперт
Перейти к: навигация, поиск

Cast value to float

   <source lang="sql">

12> 13> SET NOCOUNT ON 14> DECLARE @float1 float 15> SET @float1 = CAST(POWER(10,9) as float) 16> SELECT @float1 * @float1 * @float1 * @float1 * 100 AS "Large Float value", 17> FLOOR(LOG10(@float1 * @float1 * @float1 * @float1 * 100) 18> + 1) AS "Number of digits" 19> GO Large Float value Number of digits


------------------------
 9.9999999999999998E+37                       39

1> 2>

      </source>