Add a column to a table in and change the datatype of a table column in T-SQL
Example
ALTER TABLE myTable ADD myColumn Int NOT NULL Default 0
ALTER TABLE myTable ALTER COLUMN myColumn varchar(50) NOT NULL
See also
Use your Android as a remote for garage door