Home Forums SQL Server 2012 SQL 2012 - General convert float to nvarchar not working RE: convert float to nvarchar not working

  • December 5, 2016 at 12:15 pm

    #1916078

    sharon-472085 (12/5/2016)

    hi ,

    first thank you 🙂

    second i do it for test some of tables with float data that i need to convert to

    char. ( dont look for logic :))

    i still not understand what the probolem to convert float to same vakue as varchar 🙂

    sahron

    There's no problem. Float is an approximate numeric. This means that you don't worry about precision and scientific notation is acceptable. Decimal and Int are exact numerics, using them means that you care about every digit on them.

    Reference: https://msdn.microsoft.com/en-us/library/ms187752.aspx

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2