Update existing column datatype in MS SQL Server database without losing data

Alter existing column datatype using Alter command eg:-

Suppose in existing table "Products" column MRP datatype is decimal(18,4) and now you want to increase its limit to decimal(18,6). Use below query

ALTER TABLE Auction_Products alter column MRP decimal(18,6)

Related Alrticles

• Download sql-introduction
• Download introduction
• Download get-columns-of-a-table-sql-server
• Download convert-float-value-to-varchar-type-in-ms-sql-server
• Download sql-server-datatypes
• Download set-nocount-on-improves-sql-server-stored-procedure-performance-high
• Download how-attackers-make-sql-injection-attack-what-script-they-used-for-sql-injection
• Download how-to-make-or-use-cursor-in-sql-server
• Download count-duplicate-records-from-table-in-sql-server
• Download delete-duplicate-records-from-table-sql-server
• Download quick-fix-to-prevent-sql-injection-attach-sql-server-Asp-Net-asp
• Download how-to-make-and-use-temporary-tables-in-sql-server
• Download stored-procedure-to-make-listing-and-search-between-to-and-from-date-or-start-date-end-date
• Download use-of-begin-commit-transaction-rollback-in-a-stored-procedure-sql-server
• Download sql-injection-attack-if-you-see-in-page-view-source-http-116jurist-ru
• Download replacing-all-text-within-brackets-or-any-other-special-character-by-ms-sql-query
• Download how-to-update-data-as-first-letter-upper-case-ms-sql-query
• Download rename-a-column-name-or-table-name-stored-procedure-name-in-ms-sql-server
• Download update-existing-column-datatype-in-ms-sql-server-database-without-losing-data
• Download compare-null-values-in-ms-sql-server