problems with adding column into a table in SQL Server 2008

Question

I have a declared parameter, say @column_name varchar(200). I don't know how to add a column to a existing table with this column_name.

The following code has syntax errors.

alter table table_name add @column_name varchar(200)

Anyone know how do solve this?

juergen d · Accepted Answer · 2012-07-25 06:44:26Z

1

You have to use dynamic SQL if your want a dynamic column name:

declare @column_name varchar(100)
set @column_name = 'col_new'
exec('alter table table_name add ' + @column_name + ' varchar(200)')

answered Jul 25, 2012 at 6:44

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1