Cast value to float : float « Data Type « SQL Server / T-SQL

1. SQL Server / T-SQL
2. Data Type
3. float

Cast value to float

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>
           
       

Related examples in the same category