Altering column size in SQL Server

March 13, 2021 by Code Error

How to change the column size of the salary column in the employee table from numeric(18,0) to numeric(22,5)

Solution

ALTER TABLE [Employee]
ALTER COLUMN [Salary] NUMERIC(22,5) NOT NULL

Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.