当天建立第二天的表 create proc sp_test as begin declare @sql varchar(3000) set @sql = 'create table tbname'+convert(varchar(8),getdate()+1,112)+'(a int)' exec (@sql) end
use test godeclare @str varchar(100) set @str=replace(replace(replace(convert(varchar(50),getdate(),120),'-',''),':',''),' ','') print @str --20100927133653 2010-09-27 13:36:53 exec('create table tb_'+@str+' ( id int identity(1,1), col int )')--创建数据表:tb_20100927133653
create proc sp_test
as
begin
declare @sql varchar(3000)
set @sql = 'create table tbname'+convert(varchar(8),getdate()+1,112)+'(a int)'
exec (@sql)
end
godeclare @str varchar(100)
set @str=replace(replace(replace(convert(varchar(50),getdate(),120),'-',''),':',''),' ','')
print @str --20100927133653 2010-09-27 13:36:53
exec('create table tb_'+@str+'
(
id int identity(1,1),
col int
)')--创建数据表:tb_20100927133653