Add column, with default value, to existing table in SQL Server

ALTER TABLE {TABLENAME}
ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL}
CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE}

ALTER TABLE Protocols
ADD ProtocolTypeID int NOT NULL DEFAULT(1)
GO

ALTER TABLE <table name>
ADD <new column name> <data type> NOT NULL
GO
ALTER TABLE <table name>
ADD CONSTRAINT <constraint name> DEFAULT <default value> FOR <new column name>
GO

ALTER TABLE myHappyTableName
ADD RecordAddedDate smalldatetime NULL DEFAULT(GetDate())
GO

ALTER TABLE table
ADD column BIT NOT NULL
CONSTRAINT Constraint_name DEFAULT 0 WITH VALUES

ALTER TABLE ADD ColumnName Options

ALTER TABLE DEPT
ADD (Manger_id Number(3) NULL, Location_id Number (4) NULL,
CONSTRAINT departments_department_id_fk FORIGN KEY (Id)
REFERENCE departments (department_Id));

UPDATE dbo.YourTable
SET dbo.YourTable.NewColumn = SourceServer.SourceDB.dbo.SourceTable.Column
FROM dbo.YourTable as y
    INNER JOIN SourceServer.SourceDB.dbo.SourceTable.Column as s
    ON (y.ColumnID = s.ColumnID);
GO