Dynamic SQL column names

• hernandezjf

  SSC Enthusiast

  Points: 180

  More actions

  February 10, 2003 at 2:45 pm

  #158829

  Is there a way to create a table with columns based on sql variables (i.e. create table #table1 (@strColumnName varchar(20) null)

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  February 10, 2003 at 3:00 pm

  #448581

  Yep something like:

  declare @c char(10)

  declare @cmd char(100)

  set @c = 'test_column'

  set @cmd = 'create table tempdb.dbo.test (' + @c + ' int)'

  exec(@cmd)

  insert into tempdb.dbo.test values (1)

  select * from tempdb.dbo.test

  drop table tempdb.dbo.test

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP