sp_rename with variable

• da-221236

  SSC-Addicted

  Points: 422

  More actions

  December 27, 2005 at 8:31 am

  #103004

  Hi,

  I would like to use sp_rename but with a variable to name the new table.

  For example,

  exec sp_rename 'table_1','table_OLD'

  I would ideally like to replace the "OLD" with:

  convert(varchar(50), getdate(),112)

  which would append the date to the rename table.

  This throws up errors. I have tried nesting this in a @sql = '' but with little luck.

  Thanks

  Dave

• gbn

  SSCertifiable

  Points: 6429

  More actions

  December 27, 2005 at 8:35 am

  #611531

  Use this:

  declare @newname varchar(56)

  set @newname = 'table_' + convert(varchar(50), getdate(),112)

  exec sp_rename 'table', @newname

   

• da-221236

  SSC-Addicted

  Points: 422

  More actions

  December 27, 2005 at 8:39 am

  #611533

  thats great. should have thought about that one a bit more.

  Thanks