sql sql-server database t-sql alter-table

Altering column size in SQL Server

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

Return time difference in the format hh:mm:ss in SQL
Getting only Month and Year from SQL DATE
Retrieving Most Recent Status Value before A given transaction date
Can't remove single Quote in SQL
How do I get matched pairs of results (1 male and 1 female) with the same age at random?
SQL Server Operating system error 5: "5(Access is denied.)"
ERROR: extra data after last expected column on PostgreSQL while the number of columns is the same
How to get the 30 days before date from today's date
How to get the date 30 days before today's date from database
What are the disadvantages to Indexes in database tables?
Default parameter in SQL where clause
How to display full text and all rows in DuckDB console results?
How can I filter words in SQL using a function?
Getting the second occurrence from charindex function in sql server
Search a PHP array for number of characters
Microsoft Access: How to pass parameter from main query to subquery
Get number of Oracle DB transactions
SQL vs CODE, Where is the balance?
postgres locking with UPDATE FOR and foreign keys
Inserting root id to all its children
How do databases maintain results if another query edits those results
Transaction deadlock for select query
MySQL MAX() function returns NULL on empty table - How to get an empty result set instead?
Crosstab in SQL Server with a column that may have no data
How can I translate the FileNet ID ID in DB2/Oracle into friendly GUID?
Many to Many Self referencing relationship
MS Access error "ODBC--call failed. Invalid character value for cast specification (#0)"
How to instantiate user @variables?
Issue with parameters of SQLAlchemy execute()
Multiple select queries with union, flatten to single row