blocks|key|1857772|text|转到企业管理器，设计表，单击您的字段。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1857773|生成一个十进制列|1857774|在底部的属性中有一个精度属性|1857775|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

Go to enterprise manager, design table, click on your field.

Make a decimal column

In the properties at the bottom there is a precision property

blocks|key|2071636|text|ALTER+TABLE+Testing+ALTER+COLUMN+TestDec+decimal(16,1)|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2071637|只需放入decimal(precision,+scale)，将精度和小数位数替换为所需的值。|unstyled|offset|length|style|CODE|2071638|我没有使用表中的数据对此进行任何测试，但如果更改精度，如果新的精度较低，则可能会丢失数据。|2071639|entityMap^0|0|4|P|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|P|8|@$G|Q|H|R|I|J]]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|F|7|T|8|@]|9|@]|A|$]]]|N|$]]

<pre><code>ALTER TABLE Testing ALTER COLUMN TestDec decimal(16,1)
</code></pre>

Just put <code>decimal(precision, scale)</code>, replacing the precision and scale with your desired values.

I haven't done any testing with this with data in the table, but if you alter the precision, you would be subject to losing data if the new precision is lower.

blocks|key|2071651|text|也许有一种更好的方法，但您始终可以将列复制到新列中，删除它，然后将新列重新命名为第一列的名称。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2071652|也就是说：|2071653|ALTER+TABLE+MyTable+ADD+NewColumnName+DECIMAL(16,+2);
GO

UPDATE++MyTable
SET+++++NewColumnName+=+OldColumnName;
GO

ALTER+TABLE+CONTRACTS+DROP+COLUMN+OldColumnName;
GO


EXEC+sp_rename
++++@objname+=+'MyTable.NewColumnName',
++++@newname+=+'OldColumnName',
++++@objtype+=+'COLUMN'
GO|code-block|syntax|javascript|2071654|这是在SQL+Server2008+R2上测试的，但应该可以在SQL+Server+2000%2B上工作。|2071655|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

There may be a better way, but you can always copy the column into a new column, drop it and rename the new column back to the name of the first column.

to wit:

<pre><code>ALTER TABLE MyTable ADD NewColumnName DECIMAL(16, 2);
GO

UPDATE MyTable
SET NewColumnName = OldColumnName;
GO

ALTER TABLE CONTRACTS DROP COLUMN OldColumnName;
GO


EXEC sp_rename
 @objname = 'MyTable.NewColumnName',
 @newname = 'OldColumnName',
 @objtype = 'COLUMN'
GO
</code></pre>

This was tested on SQL Server 2008 R2, but should work on SQL Server 2000+.

blocks|key|1857798|text|ALTER+TABLE+`tableName`+CHANGE++`columnName`+DECIMAL(16,1)+NOT+NULL;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1857799|我用这个来做修改。|unstyled|1857800|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>ALTER TABLE `tableName` CHANGE `columnName` DECIMAL(16,1) NOT NULL;
</code></pre>

I uses This for the alterration

blocks|key|2071680|text|ALTER+TABLE+(Your_Table_Name)+MODIFY+(Your_Column_Name)+DATA_TYPE();|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2071681|对于您的问题：|unstyled|2071682|ALTER+TABLE+(Your_Table_Name)+MODIFY+(Your_Column_Name)+DECIMAL(Precision,+Scale);+|2071683|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|L|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|I|3|-4|5|F|7|N|8|@]|9|@]|A|$]]]|J|$]]

<pre><code>ALTER TABLE (Your_Table_Name) MODIFY (Your_Column_Name) DATA_TYPE();
</code></pre>

For you problem: 

<pre><code>ALTER TABLE (Your_Table_Name) MODIFY (Your_Column_Name) DECIMAL(Precision, Scale); 
</code></pre>

blocks|key|2071767|text|在Oracle+10G和更高版本中，以下语句将起作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2071768|ALTER+TABLE+<TABLE_NAME>+MODIFY+<COLUMN_NAME>+<DATA_TYPE>|offset|length|style|CODE|2071769|如果当前数据类型为NUMBER(5,2)，而您希望将其更改为NUMBER(10,2)，则以下语句|2071770|ALTER+TABLE+<TABLE_NAME>+MODIFY+<COLUMN_NAME>+NUMBER(10,2)|2071771|entityMap^0|0|0|1L|0|0|0|1M|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@$D|T|E|U|F|G]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|M|$]]

In Oracle 10G and later following statement will work.
<code>ALTER TABLE &lt;TABLE_NAME&gt; MODIFY &lt;COLUMN_NAME&gt; &lt;DATA_TYPE&gt;</code>
If the current data type is NUMBER(5,2) and you want to change it to NUMBER(10,2), following is the statement
<code>ALTER TABLE &lt;TABLE_NAME&gt; MODIFY &lt;COLUMN_NAME&gt; NUMBER(10,2)</code>

Is there a way to alter the precision of an existing decimal column in Sql Server?

How do I alter the precision of a decimal column in Sql Server?

SQL Server

有没有办法改变Sql Server中现有小数列的精度？

问如何在Sql Server中更改小数列的精度？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Sql Server中更改小数列的精度？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Sql Server中更改小数列的精度？
EN