DECLARE @table varchar(500)
DECLARE @Q varchar(2000 )
SET @table='SQLTABLE_' +(CONVERT(VARCHAR(8),GETDATE(),112))
SET @Q= 'CREATE TABLE '+  @table + ' (Id int, Name [nvarchar](50) NULL)'
Exec(@Q)

7 responses to “Append SQL table name with today’s date with SQL Query”

1. HI, do u have any idea on Paypal integration with .net

   i need to used Dodirectpayment method of paypal . pls let me know if u have any idea.

   Reply

   • yes. i do have knowledge abt Paypal integration with .net. what u what know? here is my emailid [email protected]

     Reply

     • thanks buddy.actually i m done with it using paypal’s SDK .thnks for reply.keep posing articles.

       Reply

2. You made my day, let me try to implement it now.

   Reply

3. Thanks very much. This is what I exactly needed.

   Reply

4. I am trying to schedule a query that will run against a new table that is created every day. The table is named “tableName20120725”. How can i write a query that can account for the table name changing?

   Reply

5. Thank you so much… very helpful….

   Reply