how to turn off scientific notation in sql server

In SQL Server, you can convert scientific notation numbers to regular numeric format using the CAST or CONVERT function.

For example, suppose there is a column named “number” containing numbers in scientific notation, you can use the following method to remove scientific notation:

1. Utilize the CAST function.

SELECT CAST(number AS DECIMAL(18, 2)) AS new_number
FROM your_table;

1. Utilize the CONVERT function:

SELECT CONVERT(DECIMAL(18, 2), number) AS new_number
FROM your_table;

In the example above, “number” is the column name containing numbers in scientific notation, and “your_table” is the table name containing this column. Replace DECIMAL(18, 2) with the data type and precision that suit your needs.

In this way, the query result will return the numbers without scientific notation.