adding new columns in run time

• oigo

  Old Hand

  Points: 342

  More actions

  May 4, 2003 at 1:00 pm

  #82167

  Hello, i wonder if can i add new columns in run time usign T-SQL, the name of the column is a variable, i've tried this:

  declare @v char(1)

  set @v='s'

  alter table table1

  add @v int

  but it's not work, is this no possible in sqlserver? or how i do it? thanks

• winash

  SSChampion

  Points: 11446

  More actions

  May 4, 2003 at 1:36 pm

  #456102

  I think you need to use dynamic SQL to get this done at runtime...

  something like this :

  Declare @Sql NVarchar(500)

  Declare @v Char(1)

  SET @v = 's'

  SET @Sql = 'Alter table table1 add '+@V+' int'

  Print @Sql -- for testing/debugging

  Exec sp_executesql @Sql