Creating Dynamic Tables

• George Damien Varkey

  SSC-Addicted

  Points: 440

  More actions

  September 29, 2006 at 4:38 am

  #170521

  I want to create dynamic tables, I am using the follwing script but it gives me error

  declare @tablename varchar (100)

  set @tablename = '#BackupFile_' + replace(replace(cast(getdate() as varchar),' ',''),':','')

  select @tablename

  create table @tablename

  (

  [name] [nvarchar] (100)

  )

  error :

  Incorrect syntax near '@tablename'.

• Ram Ram

  Ten Centuries

  Points: 1079

  More actions

  September 29, 2006 at 4:50 am

  #663273

  Try this.

  declare @tablename varchar (100)

  set @tablename = '#BackupFile_' + replace(replace(cast(getdate() as varchar),' ',''),':','')

  select @tablename

  EXEC ('CREATE TABLE '+@tablename+ '([name] [nvarchar] (100))')

   

  Ram

   

   

• Chris Chilvers

  SSCrazy

  Points: 2260

  More actions

  September 29, 2006 at 6:47 am

  #663287

  I would just use the convert function, something like:

  set

  @tablename = '#BackupFile_' + convert(varchar, getdate(), 112)

  Which gives values such as, #BackupFile_20060929