Declare @ColumnName as Varchar(50)
declare @ssql nvarchar(200)
declare @dataType nvarchar(150)

Set @ColumnName ='Column1'
Set @dataType ='nvarchar(50)'
set @ssql = 'Alter table Emp Add '+ @ColumnName+' '+ @dataType

print...