ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2019 www.aspforums.com. All rights reserved.Arithmetic overflow error converting float to data type numeric in SQL Server<p>Hi <a class="username" rel="iammann"> iammann</a>,</p> <p>Try below query.</p> <p><span style="text-decoration: underline;"><strong>SQL</strong></span></p> <pre class="brush: sql">DECLARE @Data NUMERIC(18,6) SET @Data = 93060000.000000 SELECT @Data AS Data</pre> <p><span style="text-decoration: underline;"><strong>Output</strong></span></p> <p><strong>93060000.000000</strong></p>https://www.aspforums.net:443/Threads/633370/Arithmetic-overflow-error-converting-float-to-data-type-numeric-in-SQL-Server/https://www.aspforums.net:443/Threads/633370/Arithmetic-overflow-error-converting-float-to-data-type-numeric-in-SQL-Server/Mon, 09 Sep 2019 04:19:19 GMTArithmetic overflow error converting float to data type numeric in SQL Server<p>THanks @<a class="username" rel="pandeyism">pandeyism</a> but i have resolved it by myself.</p> <p>&nbsp;</p> <p>I have just changed column datatype capacity 18,13 to 25,13</p>https://www.aspforums.net:443/Threads/633370/Arithmetic-overflow-error-converting-float-to-data-type-numeric-in-SQL-Server/https://www.aspforums.net:443/Threads/633370/Arithmetic-overflow-error-converting-float-to-data-type-numeric-in-SQL-Server/Tue, 10 Sep 2019 03:05:45 GMT