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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-07 : 17:09:10
|
Alex writes "When creating a table, how can you make a field not round a decimal?
i.e.
CREATE TABLE table_name (Price number)
now with that as your table, when you insert a decimal number, it rounds it. How can I stop it from rounding?
i.e.
INSERT INTO table_name(Price) VALUES(52.30)
that SQL string causes the output of
<table border="1">
<tr bgcolor="silver">
<th>Price</th>
</tr>
<tr>
<td align="right">52</td>
</tr>
</table>
I want it to be 52.30
can you help me?
Thank you,
Alex" |
|
|
|
|
|
Decimals in a database