> Thanks. Got it. Hope this function can be added in later version.

"George Shui" <GeorgeShui@discussions.microsoft.com> wrote in message
news:702F5464-2FFD-4717-A902-93A1F76E358F@microsoft.com...
> Thanks. Got it. Hope this function can be added in later version.
>
> "Dan Guzman" wrote:
>
>> > But I have one more silly question, if I use SSMS, how can I get the
>> > value
>> > as what I get by Query Analyzer 2000?
>>
>> Sorry, but I don't believe SSMS provides the option to change the display
>> behavior. You'll need to use SQLCMD in that case.
>>
>> --
>> Hope this helps.
>>
>> Dan Guzman
>> SQL Server MVP
>>
>> "George Shui" <GeorgeShui@discussions.microsoft.com> wrote in message
>> news:A61D25DD-1FA0-48E2-AB9A-CD33C1B76A84@microsoft.com...
>> > Thank you so much. You are really handing.
>> >
>> > But I have one more silly question, if I use SSMS, how can I get the
>> > value
>> > as what I get by Query Analyzer 2000?
>> >
>> > Thanks in advance.
>> >
>> >
>> >
>> > "Dan Guzman" wrote:
>> >
>> >> > Because Sql server 2005 will format the value, but sql server 2000
>> >> > will
>> >> > not.
>> >> > So my eye has cheated me.
>> >>
>> >> More accurately, SSMS will round the float value for display but Query
>> >> Analyzer, OSQL and SQLCMD will not. The underlying database value is
>> >> the
>> >> same in both SQL 2000 and SQL 2005.
>> >>
>> >> I'm glad I was able to help you out.
>> >>
>> >> --
>> >> Dan Guzman
>> >> SQL Server MVP
>> >>
>> >> "George Shui" <GeorgeShui@discussions.microsoft.com> wrote in message
>> >> news:500B18CD-97A6-4960-B4E5-5E69F7844B5B@microsoft.com...
>> >> > Thanks, you are right.
>> >> >
>> >> > Because Sql server 2005 will format the value, but sql server 2000
>> >> > will
>> >> > not.
>> >> > So my eye has cheated me.
>> >> >
>> >> > Thanks.
>> >> >
>> >> > "Dan Guzman" wrote:
>> >> >
>> >> >> > But I use the same table stucture and same SP in our Test and Dev
>> >> >> > enviroment, No such thing happen. Also I put the same xml to
>> >> >> > excute
>> >> >> > in
>> >> >> > our
>> >> >> > Test enviroment, it should be fine. Does it caused by enviroment
>> >> >> > difference
>> >> >> > or it will be saved randomly.
>> >> >>
>> >> >> I expect consistent results regardless of the environment as long
>> >> >> as
>> >> >> the
>> >> >> same value is inserted. The behavior may appear random because
>> >> >> only
>> >> >> certain
>> >> >> float values are affected For example:
>> >> >>
>> >> >> SELECT CAST(1.19 as float) --1.1899999999999999
>> >> >> SELECT CAST(1.29 as float) --1.29
>> >> >>
>> >> >> Also, tools like SSMS may format values for display purposes so you
>> >> >> will
>> >> >> see
>> >> >> 1.19 in the GUI even though the underlying database value is
>> >> >> 1.1899999999999999. SQLCMD will show the actual value:
>> >> >>
>> >> >> SQLCMD -E -S MyServer -Q"SELECT CAST(1.19 AS float)"
>> >> >>
>> >> >> --
>> >> >> Hope this helps.
>> >> >>
>> >> >> Dan Guzman
>> >> >> SQL Server MVP
>> >> >>
>> >> >> "George Shui" <GeorgeShui@discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:D3C29011-3B0A-48BC-A14C-E53073BBF56D@microsoft.com...
>> >> >> >
>> >> >> > But I use the same table stucture and same SP in our Test and Dev
>> >> >> > enviroment, No such thing happen. Also I put the same xml to
>> >> >> > excute
>> >> >> > in
>> >> >> > our
>> >> >> > Test enviroment, it should be fine. Does it caused by enviroment
>> >> >> > difference
>> >> >> > or it will be saved randomly.
>> >> >> >
>> >> >> > "Dan Guzman" wrote:
>> >> >> >
>> >> >> >> Not all decimal values can be exactly represented by float and
>> >> >> >> real
>> >> >> >> data
>> >> >> >> types. The behavior follows the IEEE 754 specification and is
>> >> >> >> why
>> >> >> >> these
>> >> >> >> a
>> >> >> >> labeled as approximate types in the Books Online.
>> >> >> >>
>> >> >> >> If you need exact decimal values, use a decimal data type.
>> >> >> >>
>> >> >> >> --
>> >> >> >> Hope this helps.
>> >> >> >>
>> >> >> >> Dan Guzman
>> >> >> >> SQL Server MVP
>> >> >> >>
>> >> >> >> "George Shui" <GeorgeShui@discussions.microsoft.com> wrote in
>> >> >> >> message
>> >> >> >> news:FB45900E-EF50-4EB7-9D45-4C2FD582C961@microsoft.com...
>> >> >> >> >I feel it strange that after float value 1.19 saved to DB, and
>> >> >> >> >it
>> >> >> >> >becomes
>> >> >> >> >to
>> >> >> >> > 1.189999..., but not all the values has this problem, only a
>> >> >> >> > few
>> >> >> >> > transactions
>> >> >> >> > will have this problem.
>> >> >> >> >
>> >> >> >> > My Table Structure
>> >> >> >> > ColumnnName float 8 not null.
>> >> >> >> >
>> >> >> >> > My SP
>> >> >> >> > Insert TableName(ColumnName)
>> >> >> >> > select ColumnName
>> >> >> >> > From openxml (@hDoc,'//Reply')
>> >> >> >> > with (
>> >> >> >> > ColumnName float './ColumnName'
>> >> >> >> > )
>> >> >> >> >
>> >> >> >> > Can anyone help me? Thanks in advance.
>> >> >> >> >
>> >> >> >>
>> >> >>
>> >>
>>