Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (20.3k points)

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

1 Answer

0 votes
by (40.7k points)

Use below code:

ALTER TABLE [Employee]

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

Related questions

0 votes
1 answer
asked Jan 5, 2021 in SQL by Appu (6.1k points)
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Jul 9, 2019 in SQL by Tech4ever (20.3k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.5k answers

500 comments

108k users

Browse Categories

...