Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
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.4k points)

Use below code:

ALTER TABLE [Employee]

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

Related questions

0 votes
1 answer
asked Jan 5 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!

28.4k questions

29.7k answers

500 comments

94.1k users

Browse Categories

...