I want to change table names dynamically.something like this:
Declare @NP varchar(50) = 'alCustomers'+ Left(getDate(),
EXEC sp_rename 'dbo.Customer', 'SalCustomers;
However, I do not seem to be able to do this. So how can I concatenate a Name wiih a date to dynamically change a table name.