SQL Server - Transact-SQL

1. MODIFY Column Data Type

ALTER TABLE <table name> ALTER COLUMN <Column Name> <New Data Type> <allow null>;

ALTER TABLE TB_EXAM ALTER COLUMN INTEREST_RATE Float null;

2. ADD Column Data Type

ALTER TABLE <table name> ADD <Column Name> <New Data Type> <allow null>;

ALTER TABLE TB_EXAM2 ADD INTEREST_RATE Numeric(18,3) not null;