How to change the column size of the salary
column in the employee
table from numeric(18,0)
to numeric(22,5)
Advertisement
Answer
ALTER TABLE [Employee] ALTER COLUMN [Salary] NUMERIC(22,5) NOT NULL
How to change the column size of the salary
column in the employee
table from numeric(18,0)
to numeric(22,5)
ALTER TABLE [Employee] ALTER COLUMN [Salary] NUMERIC(22,5) NOT NULL