asked
0 and -O values while converting from sql 2000 to sql 2008
We recently upgraded on of our applications to sql 2008 from 2000 while trying to insert from a query it's inserting -0 instead of
zero.It's converting from float to varchar....Did any body have the similar issue thanks in advance...
So your float is a small negative number (eg -0.00000001), and that's being converted to a varchar '-0'? How is the conversion happening?
I've never seen anything like this on any of the upgrades I've done. I haven't heard about it from any other sources either. It's got to be something in the code that 2000 was somehow more forgiving on.
That is not one I've run into or seen. It sounds like either the code, the query, or the stored procedure is using the wrong data type. From that you're getting an implicit conversion. It is possible that the changes in ADO connectivity between 2000 and 2008 could be leading to the cause. We had issues with code that was querying data types from the table prior to generating inserts that came down to a change in how ADO handled that. You may also look there.
16 People are following this question.
