Altering column size in SQL Server

Question

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

Answer 1

Use below code:

ALTER TABLE [Employee]

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