Shulou(Shulou.com)05/31 Report--

This article mainly explains how to solve the problem of "how to solve the problem that the result of SQL division in MSSQL is a decimal but shows 0". The content of the explanation in the article is simple and clear, and it is easy to learn and understand. please follow Xiaobian's train of thought to slowly deepen together to study and learn how to solve the problem that the result of SQL division in MSSQL is a decimal number but shows zero.

Today, in the SQL division operation with MSSQL, it is found that the result has decimals, but when the integer part is 0, the result is directly displayed as 0. After a flip test, the solution is found and shared.

Suppose you have the following SQL division operation:

Select field1/field2 from table

Assuming that the result of the operation should be 0.123, but the actual operation is directly displayed as 0 in the MSSQL query Editor, is there any way to show the real result? The method is to cast the data type of the molecular field1 to float, as follows:

Select cast (field1 as float) / field2 from table

Thank you for your reading, the above is the content of "how to solve the problem that the result of SQL division operation in MSSQL is decimal but shows 0". After the study of this article, I believe you have a more profound understanding of how to solve the problem of how to solve the problem that the result of SQL division operation is decimal but shows zero in MSSQL. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.