How to Add a Column in MS-SQL

In MS-SQL Server (as in many other SQL databases), in order to add a column use alter table:

alter table employee add last_bonus_date date;

The value of the new column will be NULL for all the existing rows in the table.

IN THIS PAGE