declare @tablename varchar(20)
set @tablename='Inv' + convert(varchar,getdate(),112)
exec('select * into '+@tablename+' from author')
set @tablename='Inv' + convert(varchar,getdate(),112)
exec('select * into '+@tablename+' from author')
set @tablename="aaa"
exec('select * into '+@tablename+' from yourtable')
declare @tablename varchar(20)
set @tablename='Inv' + convert(varchar,getdate(),112)
exec('select name,isnull(bookname,'N') as E into '+@tablename+' from author')
请赐教!