Back

Explore Courses Blog Tutorials Interview Questions

Altering column size in SQL Server

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
Altering column size in SQL Server
asked Jan 5, 2021 in SQL by Appu (6.1k points)
0 votes
1 answer
Rename column SQL Server 2008
asked Jul 9, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
SQL Server: Get data for only the past year
asked Jul 29, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
T-SQL Cast versus Convert
asked Jul 9, 2019 in SQL by Tech4ever (20.3k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...