sybase数据库动态sql语句中使用临时表

--动态sql语句中只能使用全局临时表

if exists (select 1 from sysobjects where id = object_id('#comp') and type = 'U')
drop table #comp

create global temporary table #comp(
compno VARCHAR(12),
compname VARCHAR(120),
nodeno VARCHAR(8)
)

DECLARE @sql LONG VARCHAR
--DELETE FROM #comp

INSERT INTO #comp SELECT compno, compname,nodeno FROM cardcom WHERE compno='301425'

SET @sql='SELECT * FROM #comp'
EXECUTE (@sql)

 

--搞不懂为什么一定要加这一句，否则会报错

SELECT * FROM #comp