Altering column size in SQL Server

Question

1 Answer

0 votes

1 answer

asked Jul 6, 2019 in SQL by Tech4ever (20.3k points)

0 votes

1 answer

asked Jul 9, 2019 in SQL by Tech4ever (20.3k points)

0 votes

1 answer

asked Jan 7, 2021 in SQL by Appu (6.1k points)

0 votes

1 answer

asked Jan 5, 2021 in SQL by Appu (6.1k points)

0 votes

1 answer

asked Jan 5, 2021 in SQL by Appu (6.1k points)

Mano · Answer 1 · 2021-01-05T17:29:27+0000

answered Jan 5, 2021 by Mano (12.7k points)

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.