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 |
|
x12179x
Starting Member
4 Posts |
 Posted - 2010-03-22 : 02:17:23
|
| Is there a data type that displays all the values in scientific notation (i.e. 100 as 1.0E+02)?I use 'Real' but it displays Scientific notation only when the number is greater or equal to 10,000,000 (1.0E+07). However, If I type in 1,000,000 it is NOT displayed as 1.0E+06, but remains 1000000. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-03-22 : 02:21:45
|
this is a presentation issue. It has nothing to do with SQL Server. How do you want to present the data / value should be the job of your front end application or reporting tool where the data / value is being shown
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
x12179x
Starting Member
4 Posts |
Posted - 2010-03-22 : 03:24:25
|
| Oh ok.I use C# datagrid to display the datatable and have not found a way to do it there yet. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-03-22 : 03:27:54
|
i do not know C#, so can't help you with this. Perhaps you can try posting this at MSDN C# forum
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
Scientific Notation in MS SQL Server 2005