一个错误
执行下面的语句的时候,虽然不提示错误,但是在查询临时表的时候,却查无内容。
decare @n nvarchar(10),@s nvarchar(100) set @n = ‘临时表名’ set @s = N’select * into’+@n+‘from 数据源表’ –print @s exec sp_executesql @s
动态创建全局临时表
DECLARE @n nvarchar(10),@s nvarchar(100) SET @n = ‘临时表名’ SET @s = N’SELECT * INTO ##’+@n+‘FROM 数据源表’ –print @s EXEC sp_executesql @s
把永久表当临时表使用,创建、删除都要谨慎哦
DECLARE @n nvarchar(10),@s nvarchar(100) SET @n = ‘临时表名’ SET @s = N’SELECT * INTO’+@n+‘from 数据源表’ –print @s EXEC sp_executesql @s