Rename TableName To Datetime

• Jan A

  SSC-Addicted

  Points: 405

  More actions

  June 23, 2008 at 12:04 am

  #123431

  Hi.

  I'm working on a script that moves data from one table to another (This one is created dynamic).

  I'm using:

  USE ping_statistics

  GO

  SELECT * INTO PING_Temp

  FROM Hostbackup

  EXEC sp_rename 'PING_Temp', 'HostInfo_(getdate)'

  Where I would like the name of the new table to be

  "PING_2008" Where 2008 is the current year.

  Can anyone help me here?

  \Jan.

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  June 23, 2008 at 2:50 am

  #832510

  declare @TableName char(50)

  select @TableName = 'PING_' + left(convert(char(50), getdate(), 120), 4)

  print @TableName

  execute sp_rename 'PING', @TableName