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)

Browse Categories

...