To Add Column Through Stored Procedure.

you can pass the name 

of column as parameter 

CREATE PROCEDURE AddColumnToTable
@columnName VARCHAR(128)
AS
EXEC ('ALTER TABLE tableName ADD' + SPACE(1) +

 @columnName + SPACE(1) + 'VARCHAR(MAX) NULL')