A workaround for SQL division operations in MSSQL with a decimal number showing 0 _mssql

Today in the use of MSSQL SQL Division operations, found that the results have decimal, and the whole division is divided into 0 o'clock, the result is directly displayed as 0, after a test found a solution to share.

Suppose there is a section of SQL division that follows:

Select Field1/field2 from table

Assuming that the result of the operation should be 0.123, but the actual operation in the MSSQL Query Editor directly displayed as 0, then to show its true results, what is the way? The method is to cast the data type of the molecular field1 to the float type, as follows:

Select cast (field1 as float)/field2 from table