<div>
declare @newname varchar(20)<br />
set @newname = &nbsp;convert(varchar(2), day(GetDate()) ) + convert( VARCHAR(2) , MONTH(GETdATE())) <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;+ convert(char(4), Year(getdate()))<br />
<br />
set @newname &nbsp;= @newname + '_abc' <br />
exec sp_rename 'Table1', @newname
</div>


declare @newname varchar(20)
set @newname =  convert(varchar(2), day(GetDate()) ) + convert( VARCHAR(2) , MONTH(GETdATE()))
               + convert(char(4), Year(getdate()))

set @newname  = @newname + '_abc'
exec sp_rename 'Table1', @newname

<div>
Missed it by &gt;&nbsp;that&lt; much....well done KarinLoos
</div>


Missed it by > that< much....well done KarinLoos

<div>
more:<br />
<a href="http://www.kofler.cc/mysql/mssql2mysql.html" rel="ugc">http://www.kofler.cc/mysql/mssql2mysql.html</a><br />
<a href="http://www.kofler.cc/mysql/mssql2mysql-gui2.zip" rel="ugc">http://www.kofler.cc/mysql/mssql2mysql-gui2.zip</a>
</div>


more:
http://www.kofler.cc/mysql/mssql2mysql.html [http://www.kofler.cc/mysql/mssql2mysql.html]
http://www.kofler.cc/mysql/mssql2mysql-gui2.zip [http://www.kofler.cc/mysql/mssql2mysql-gui2.zip]

<div>
Hey rikroket....as much as I appreciate the points....I was second with the answer. :-)
</div>


Hey rikroket....as much as I appreciate the points....I was second with the answer. :-)

<div>
<div class="content wysiwyg-content">
I would like to rename a table by appending the current date to the front of a table name.<br />
For example:<br />
<br />
Rename this table: Table1<br />
To: 02212005_Table1 (month, day, year)<br />
<br />
How can I perform this using dynamic SQL or by using sp_rename?<br />
<br />
Thanks in advance . . .<br />
<br />
Rik
</div>
</div>


I would like to rename a table by appending the current date to the front of a table name.
For example:

Rename this table: Table1
To: 02212005_Table1 (month, day, year)

How can I perform this using dynamic SQL or by using sp_rename?

Thanks in advance . . .

Rik

Rename table using dynamic SQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.