How to Create a table in SQL with a table name depending on the date the code is run ?

For e.g. Create table tempOCT as Select....
If i run the code in any day of Nov the table name should be tempNOV.

Interview Candidate
Oct 31st, 2007
6
1666

Showing Answers 1 - 6 of 6 Answers

Waseem Mehmood
Profile Answers by Waseem Mehmood

Nov 20th, 2007

I think it is not possible, i try to concate date with table name but no vail.
You can not rename the table name by cancating date

vishal gupta

Nov 21st, 2007

You can do one this in the code itself that is going to create the table at run time incorporate the logic to get the currect date, take it as string variable and then in the code itself you can write the query Create table as(..)

Might help you.

Vishal.