<div>
could you post an exemple of what would be a proper format ?<br />
<br />

</div>


could you post an exemple of what would be a proper format ?



<div>
<div class="content wysiwyg-content">
Hi,<br />
My Project Backend is MS.SQL 7.0.<br />
In a table there is one field amt_amount, type is Float, Lentgh is 8 and &nbsp;Prec is 53.<br />
<br />
Now the problem is, in case of large value it is not coming in a proper format, it is showing like &nbsp;&quot;1.3854593718367629E+18&quot;. I need to show it in proper format, how to solve this problem.<br />
The of table creation is <br />
&quot;Create Table T_STK amt_amount float (53)&quot;<br />
<br />
Please, help me to solve this problem.<br />
<br />
Thanks &amp;&nbsp;Regards,<br />
Anirban Das Gupta.<br />
<br />

</div>
</div>


Hi,
My Project Backend is MS.SQL 7.0.
In a table there is one field amt_amount, type is Float, Lentgh is 8 and  Prec is 53.

Now the problem is, in case of large value it is not coming in a proper format, it is showing like  "1.3854593718367629E+18". I need to show it in proper format, how to solve this problem.
The of table creation is 
"Create Table T_STK amt_amount float (53)"

Please, help me to solve this problem.

Thanks & Regards,
Anirban Das Gupta.



SQL Amount Format

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.