Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

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

Tags:

sql-server

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

like image 968
Andrew Jones Avatar asked Sep 23 '08 09:09

Andrew Jones

People also ask

How do I change the precision of a column in SQL?

Just put decimal(precision, scale) , 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.

How do I increase the length of a decimal in SQL?

SQL CAST() inside AVG() for decimal value The CAST() is used to increase or decrease the decimal places of a value. The CAST() function is much better at preserving the decimal places when converting decimal and numeric data types.

1 Answers

ALTER TABLE Testing ALTER COLUMN TestDec decimal(16,1)

Just put decimal(precision, scale), 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.

like image 200
VanSkalen Avatar answered Sep 22 '22 02:09

VanSkalen
Sign in to Comment

Related questions

How to do a Postgresql subquery in select clause with join in from clause like SQL Server?
How to convert a datetime to string in T-SQL
How to query DATETIME field using only date in Microsoft SQL Server?
How to copy a row from one SQL Server table to another
Index was outside the bounds of the Array. (Microsoft.SqlServer.smo)
Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
How can I have multiple common table expressions in a single SELECT statement?
Calculating distance between two points (Latitude, Longitude)
SQL server ignore case in a where expression
SQL Row_Number() function in Where Clause
How do I grant myself admin access to a local SQL Server instance?
How to read the last row with SQL Server
Listing information about all database files in SQL Server
Horrible performance using SqlCommand Async methods with large data
Can you have if-then-else logic in SQL? [duplicate]
Drop a temporary table if it exists
SQL NVARCHAR and VARCHAR Limits
Like Operator in Entity Framework?
Dynamic SQL - EXEC(@SQL) versus EXEC SP_EXECUTESQL(@SQL)
INSERT vs INSERT INTO

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!