Rename TableName To Datetime

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Rename TableName To Datetime

Rename TableName To Datetime

Rate Topic

Display Mode

Topic Options

Author

Message

Jan A

Posted Monday, June 23, 2008 12:04 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, February 17, 2010 12:47 PM
Points: 11, Visits: 109

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.

Post #521538

Suresh B.

Posted Monday, June 23, 2008 2:50 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 4:49 AM
Points: 1,075, Visits: 5,119

declare @TableName char(50)
select @TableName = 'PING_' + left(convert(char(50), getdate(), 120), 4)
print @TableName
execute sp_rename 'PING', @TableName

Post #521588

« Prev Topic | Next Topic »

Permissions