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...
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.