Create variable name for table

Question

I'm wondering if it is possible to create a variable name when copying a table to another.

Here's my sort-of algorithm/code

DECLARE @NewTableName VARCHAR(50)
SET @NewTableName = 'MyTable_'+GETDATE() --MyTable_12282010 (for example)

SELECT *
INTO @NewTableName
FROM MyTable

I'm wondering if this is possible. I tried it before, but it failed. Any suggestions guys?

Mitch Wheat · Accepted Answer · 2010-12-29 07:21:08Z

4

It is possible, but only using dynamic TSQL.

See sp_executesql (or the 2000 version sp_executesql)

answered Dec 29, 2010 at 6:55

Mitch Wheat

302k44 gold badges482 silver badges552 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

is it applicable for sql server 2000?

@Musikero31: if this answer (or another) is helpful, please don't forget to mark it as 'Accepted'