Altering column size in SQL Server

Question

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

Answer 1

You can use the following code:

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

Kick-start your career in SQL with this perfect SQL Course by Intellipaat now!

Watch this video tutorial on how to become a professional in SQL.