Re: Automatically create table name

the sp_rename stored procedure can help you:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ra-rz_3ns5.asp

exec sp_rename 'Customer_20050708', 'Customer_20050709'



"Kris" <Kris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4B165AD1-3BC4-4341-A9C1-8706E1B12651@xxxxxxxxxxxxxxxx
> Hi All,
>
> I want to rename table automatically .How can i do this ?
>
> from example table name is Customer --> wants to rename every day as
>
> Customer --> Customer_20050708 on next day
> Customer --> Customer_20050709
>
> any help ..
> Thanks
>


.

Relevant Pages

  • Re: noise words, @@ERROR, and stop and resume indexing
    ... EXEC sp_fulltext_catalog 'adsfull', 'stop' ... > 1) check noise words inside stored procedure ... > can be solved by changing the language specific file with noise words ... ...
    (microsoft.public.sqlserver.fulltext)
  • source text file as input parameter from a stored procedure
    ... I am using an active X script in combination with a global ... transform task that loads data from a .txt file to a table. ... I can also tell that the stored procedure is correctly passing in the ... EXEC sp_OAGeterrorinfo @object, @hr ...
    (microsoft.public.sqlserver.dts)
  • Re: Repeating 3 Datapump actions between the same datasource/destinati
    ... How to loop through a global variable Rowset ... > exec p_PullDataForDates1 20050101,20050131 ... > task that configure the SourceSQLStatement for the 2 pumps (to fill in the ... > blanks for the stored procedure parameter). ...
    (microsoft.public.sqlserver.dts)
  • Re: Stored Procedure Fails Only When Called By Agent
    ... Stored Procedure 1: ... EXEC sp_addlinkedserver '10.1.2.10', 'SQL Server' ... LOCALMACHINE\myaccount/pass3, the same account that owns the job. ...
    (microsoft.public.sqlserver.replication)
  • Re: Please Help
    ... Remember, he wants to do this in a stored procedure, thus preventing the use ... exec sp_addlogin @user,@user ... > --create new sql login ... > --add to pubs datareader role ...
    (microsoft.public.sqlserver.security)