Skip to content
Fix Code Error

Altering column size in SQL Server

March 13, 2021 by Code Error
Posted By: Anonymous

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

Solution

ALTER TABLE [Employee]
ALTER COLUMN [Salary] NUMERIC(22,5) NOT NULL
Answered By: Anonymous

Related Articles

  • How to get second-highest salary employees in a table
  • delete item in array of struct that has char array member in…
  • How to verify strings and doubles in switch satements
  • PL/SQL ORA-01422: exact fetch returns more than requested…
  • Find max and second max salary for a employee table MySQL
  • 'WITH' clause does not work with in operator
  • Why do we always prefer using parameters in SQL statements?
  • Spring rest service to return multiple entity classes as xml…
  • PHP A Good way to pass the PDO Object into other Main…
  • Iterating through a List Object in JSP

Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.

Post navigation

Previous Post:

How to trigger event in JavaScript?

Next Post:

Is there a float input type in HTML5?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

  • Get code errors & solutions at akashmittal.com
© 2022 Fix Code Error