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 |
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
 Posted - 2009-11-09 : 11:12:14
|
| Hi,I have the following number/text on a field 3.95439e+008, im having problems with this number, how would i be able to convert to a whole complete number without the e+008 etc?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-09 : 11:17:34
|
| use round() function |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-09 : 11:17:56
|
| http://doc.ddart.net/mssql/sql70/ra-rz_20.htm |
|
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2009-11-09 : 11:44:31
|
There are no decimal places:The values are like 2532892409and it turns into 3.098e-0493quote:
Originally posted by visakh16
use round() function
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-09 : 11:45:59
|
| what?? whats the datatype of the field? |
|
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2009-11-09 : 11:46:54
|
'int'The data is being uploaded to sql from access database.quote:
Originally posted by visakh16
what?? whats the datatype of the field?
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-09 : 11:49:29
|
| are you seeing this format at the front end? |
|
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2009-11-09 : 11:54:34
|
The issue im having is, ive got a trigger which finds afew products and loads all the data for that product onto a different table on the database. and the error being given when doing insert is:String or binary data would be truncated.quote:
Originally posted by visakh16
are you seeing this format at the front end?
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-09 : 11:57:38
|
| that means its trying to put some data to string field which does not have enough length to hold it |
|
|
|
|
|
|
Formatting Numbers