drop table @backtable表名能否用变量实现,急

[huli6666]

我的目的简单，就想删除的表,但表名是变化的，所以要用变量

同时创建个表也是
表明按日期来命名也不行,
执行完成存储过程后,表名居然是@backtable,郁闷!
declare @backtable varchar(8)
set @backtable=convert(char(8),getdate(),112)
if exists (select * from sysobjects where id = object_id(N'[mubiao].[dbo].[' + @backtable + ']'))
drop table 'T1'+ @backtable

CREATE TABLE 'T1'+ @backtable (
[a] [nchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL,
[b] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL,
[c] [int] NULL,
CONSTRAINT [PK_@backtable] PRIMARY KEY CLUSTERED
(
[a] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

[v1ctory1216]

用定义表函数能行不？

[huli6666]

谢谢，办法很好!

[Garnett_KG]

declare @backtable varchar(8)
set @backtable=convert(char(8),getdate(),112)
if exists (select * from sysobjects where id = object_id(N'[mubiao].[dbo].[' + @backtable + ']'))
EXEC ('drop table T1'+ @backtable)

[永生天地]

declare @backtable varchar(8)
set @backtable=convert(char(8),getdate(),112)

if exists (select * from sysobjects where id = object_id(N'[mubiao].[dbo].[' + @backtable + ']'))
exec('drop table T1'+ @backtable)
exec('
CREATE TABLE T1'+ @backtable+' (
[a] [nchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL,
[b] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL,
[c] [int] NULL,
 CONSTRAINT [PK_@backtable] PRIMARY KEY CLUSTERED  
(
[a] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]'
)

[永生天地]

declare @backtable varchar(8)
set @backtable=convert(char(8),getdate(),112)

if exists (select * from sysobjects where id = object_id(N'[mubiao].[dbo].[' + @backtable + ']'))
exec('drop table T1'+ @backtable)
exec('
CREATE TABLE T1'+ @backtable+' (
[a] [nchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL,
[b] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL,
[c] [int] NULL,
 CONSTRAINT [PK_'+@backtable+'] PRIMARY KEY CLUSTERED  
(
[a] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]'
)