Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Transact-SQL (2008)  data types issue

Author  Topic  tech1 Starting Member 49 Posts Posted - 2014-05-14 : 07:01:54 I have a database which the schema was created and I imported data from excel (they exported it from their SQL Server database into excel format) I am running SQL Server 2008R2 + updates They are running SQL Express 2008 R2 The problem is, on my system I am reading the values using .NET. A specific column of type decimal should actually be of double. The value of this column is "0" on my side, I read the data using GetDouble and that is fine - it gives me 0.0 on their side, they get an error saying it cannot cast it to the right type. The value they get when they read is "0" how can this be? I mean, same code completely, same database types, same data but reads it differently? I am not sure how to go about fixing this or where to look on why the reading is different on both databases? I would appreciate any help. To sum up: reading the SAME data using the SAME code is bringing back a different data type.