date/timestamp in table name

• sqlstar2011

  SSCertifiable

  Points: 6000

  More actions

  June 12, 2007 at 7:38 am

  #117518

  would someone share with me the command used to create a table with current timestamp or date appended to the name.. e.g.

  create table city06112007

  how can I appened today's date to table name?

  thanks

• Anders Pedersen

  SSChampion

  Points: 11410

  More actions

  June 12, 2007 at 7:56 am

  #712295

  Dynamic SQL.

   

  declare

  @sql varchar(2000)

  select

  @sql = 'create table TableName' + convert(varchar(12), getdate(), 112) + '(

  C1 int);'

  exec

  (@sql)

   

• sqlstar2011

  SSCertifiable

  Points: 6000

  More actions

  June 12, 2007 at 8:41 am

  #712311

  I used following and it worked:

   

  DECLARE

  @RenameTableDetail varchar(50)

  SELECT

  @RenameTableDetail = Replace(('TableDetail' + CAST ( GetDate() AS varchar (50 ))), ' ', '_')

  print

  @RenameTableDetail

  EXEC

  sp_rename @objname = 'TableDetail', @newname = @RenameTableDetail

  GO