oracle 临时表 sybase,在sybase中创建临时表

注:关于比格达多的第一个建议的更多信息。。。

先前的

#temp_table

当提交批处理时,已经存在,然后编译

create table

命令将生成错误。此行为可以在以下示例中看到:

create table #mytab (a int, b varchar(30), c datetime)

go

-- your code snippet; during compilation the 'create table' generates the error

-- because ... at the time of compilation #mytab already exists:

if object_id('#mytab') is not NULL

drop table #mytab

create table #mytab (a int, b varchar(30), c datetime)

go

Msg 12822, Level 16, State 1:

Server 'ASE200', Line 3:

Cannot create temporary table '#mytab'. Prefix name '#mytab' is already in use by another temporary table '#mytab'.

-- same issue occurs if we pull the 'create table' into its own batch:

create table #mytab (a int, b varchar(30), c datetime)

go

Msg 12822, Level 16, State 1:

Server 'ASE200', Line 1:

Cannot create temporary table '#mytab'. Prefix name '#mytab' is already in use by another temporary table '#mytab'.

-- test/drop the table in one batch:

if object_id('#mytab') is not NULL

drop table #mytab

go

-- create the table in a new batch; during compilation we don't get an error

-- because #mytab does not exist at this point:

create table #mytab (a int, b varchar(30), c datetime)

go