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.
| Author |
Topic |
|
sanjay5219
Posting Yak Master
240 Posts |
 Posted - 2014-08-15 : 10:56:46
|
| Hi All,I have created openrowset query which upload Excel to SQL. Now some time it is storing scientific value in phone (varchar). 9.74008e+0099.74008e+0099.74008e+009Please suggest how to solve this |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-08-15 : 14:36:03
|
| please post your openrowset query |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2014-08-15 : 16:47:53
|
Have you checked your IMEX setting?
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
|
|
|
|
Scientific Notation