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 |
|
govindts
Starting Member
33 Posts |
 Posted - 2009-03-19 : 13:18:10
|
| In SQL server, i have column with data type REAL. The value for that column is 6.627527E+07 NOw i converted to flat file and loading the flat file into oracle database through SQLLOADER. It is not going in oracle database.. How can i convert to number in sqlserver.. I wanted to display as full number... please help me. It is urgent... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-19 : 13:39:16
|
| just use Numeric(n,0) or Decimal(n,0) where n is max number of digits the value contain |
 |
|
|
|
|
|
Real to Number data type