Arithmetic overflow error converting float to data type numeric in SQL Server

Hi iammann,

Try below query.

SQL

DECLARE @Data NUMERIC(18,6)
SET @Data = 93060000.000000
SELECT @Data AS Data

Output

93060000.000000

THanks @pandeyism but i have resolved it by myself.

I have just changed column datatype capacity 18,13 to 25,13