dynamically creating a tablename in tsql

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » dynamically creating a tablename in tsql

dynamically creating a tablename in tsql

Rate Topic

Display Mode

Topic Options

Author

Message

Fee01

Posted Monday, March 02, 2009 2:52 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 17, 2010 8:40 AM
Points: 6, Visits: 41

hi, i'm trying to dynamically create a tablename in tsql so that the tablename contains the month and year. I keep getting an error that the stored procedure cannot be executed. can someone please tell me where i'm going wrong?

thanks!

declare @strsqlcreatetable as nvarchar(255)
declare @tablename as nvarchar(255)
declare @strsql as nvarchar(255)

select @tablename = 'lclifecycle' + convert(nvarchar(2), datepart(mm, getdate())) + convert(nvarchar(4), datepart(yyyy, getdate()))
print @tablename

select @strsqlcreatetable = 'create table ' + @tablename + '(emp int)'
print @strsqlcreatetable
exec @strsqlcreatetable

Post #666431

Dugi

Posted Monday, March 02, 2009 2:57 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252, Visits: 3,367

declare @strsqlcreatetable as nvarchar(255)
declare @tablename as nvarchar(255)
declare @strsql as nvarchar(255)

select @tablename = 'lclifecycle' + convert(nvarchar(2), datepart(mm, getdate())) + convert(nvarchar(4), datepart(yyyy, getdate()))
print @tablename

select @strsqlcreatetable = 'create table ' + @tablename + '(emp int)'
print @strsqlcreatetable
exec (@strsqlcreatetable) --there is your missing parenthesis!

Cool

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Post #666434

« Prev Topic | Next Topic »

Permissions