34,590
社区成员
发帖
与我相关
我的任务
分享
declare @temptable_ as varchar(50)
declare @vZq as varchar(8)
declare @rzrq as varchar(10)
declare @bmbm_dy as varchar(15)
declare @ckbm_dy as varchar(15)
declare @vChbm as varchar(30)
declare @djhm as varchar(18)
declare @dnxh int
declare @sql varchar(800)
select @temptable_= '#a'+replace(convert(varchar(8),getdate(),112)+convert(varchar(12),getdate(),114),':','') ,
@vZq='201001',
@rzrq='20100101',
@bmbm_dy='001',
@ckbm_dy='00101',
@vChbm='123456789012345',
@djhm='12345678901234567',
@dnxh=9
if object_id('tempdb..'+@temptable_) is null
begin
set @sql=' create table '+@temptable_ +'(t_zq varchar(8),t_rzrq varchar(10),t_bmbm varchar(15),t_ckbm varchar(15),t_chbm varchar(30),t_djhm varchar(18),t_dnxh int ,t_zy varchar(30)) '
print @sql
--exec(@sql)
set @sql=@SQL+char(13)+char(10)+'insert into '+@temptable_ +' values('''+@vZq+''','''+@rzrq+''','''+@bmbm_dy+''','''+@ckbm_dy+''','''+@vChbm+''','''+@djhm+''','+cast(@dnxh as varchar)+',''同价调拨拨入'') '
print @sql
--exec(@sql)
set @sql=@SQL+char(13)+char(10)+'select * from '+@temptable_
exec(@sql)
end
declare @temptable_ as varchar(50)
declare @vZq as varchar(8)
declare @rzrq as varchar(10)
declare @bmbm_dy as varchar(15)
declare @ckbm_dy as varchar(15)
declare @vChbm as varchar(30)
declare @djhm as varchar(18)
declare @dnxh int
declare @sql varchar(800)
select @temptable_= '#a'+replace(convert(varchar(8),getdate(),112)+convert(varchar(12),getdate(),114),':','') ,
@vZq='201001',
@rzrq='20100101',
@bmbm_dy='001',
@ckbm_dy='00101',
@vChbm='123456789012345',
@djhm='12345678901234567',
@dnxh=9
if object_id('tempdb..'+@temptable_) is null
set @sql=' create table '+@temptable_ +'(t_zq varchar(8),t_rzrq varchar(10),t_bmbm varchar(15),t_ckbm varchar(15),t_chbm varchar(30),t_djhm varchar(18),t_dnxh int ,t_zy varchar(30)) '
print @sql
--exec(@sql)
set @sql= @sql+'insert into '+@temptable_ +' values('''+@vZq+''','''+@rzrq+''','''+@bmbm_dy+''','''+@ckbm_dy+''','''+@vChbm+''','''+@djhm+''','+cast(@dnxh as varchar)+',''同价调拨拨入'') '
print @sql
--exec(@sql)
set @sql=@sql+'select * from '+@temptable_
exec(@sql)
declare @temptable_ as varchar(50)
select @temptable_= '#'+replace(convert(varchar(8),getdate(),112)+convert(varchar(12),getdate(),114),':','')
if not exists(select 1 from tempdb..sysobjects where name like @temptable_+'______________________%')
create table t(a int)
declare @temptable_ as varchar(50)
select @temptable_= '#'+replace(convert(varchar(8),getdate(),112)+convert(varchar(12),getdate(),114),':','')
if not exists(select 1 from tempdb..sysobjects where name=@temptable_+'______________________%')
create table t(a int)
if object_id('tempdb..@temptable') is null
select number into #t from master..spt_values where type='p'
go
declare @temptable_ as varchar(50)
set @temptable_= '#'+'t'
select * from tempdb..sysobjects where name like @temptable_ + '___________________________%'
/*
name id xtype uid info status base_schema_ver replinfo parent_obj crdate ftcatid schema_ver stats_schema_ver type userstat sysstat indexdel refdate version deltrig instrig updtrig seltrig category cache
-------------------------------------------------------------------------------------------------------------------------------- ----------- ----- ------ ------ ----------- --------------- ----------- ----------- ----------------------- ------- ----------- ---------------- ---- -------- ------- -------- ----------------------- ----------- ----------- ----------- ----------- ----------- ----------- ------
#t__________________________________________________________________________________________________________________00000000002C 1490104349 U 1 0 0 0 0 0 2011-07-07 18:22:56.950 0 0 0 U 1 3 0 2011-07-07 18:22:56.950 0 0 0 0 0 0 0
(1 行受影响)
*/
go
drop table #t
建臨時表需要用動態
use Tempdb
go
declare @temptable_ as varchar(50)
select @temptable_= 'Tempdb..#'+replace(convert(varchar(8),getdate(),112)+convert(varchar(12),getdate(),114),':','')
if object_id(@temptable_) is null
exec('create table ['+@temptable_+'](a int) select * from ['+@temptable_+']')