SQL创建临时表的两种方法

WITH temp AS (
    SELECT column1, column2
    FROM original_table
    WHERE conditions
)
SELECT *
FROM temp
WHERE other_conditions;

CREATE TEMPORARY TABLE temp_table AS
SELECT column1, column2
FROM original_table
WHERE conditions;

-- 然后可以在会话中随时使用 temp_table
SELECT *
FROM temp_table
WHERE other_conditions;

select * from #临时表名;
select * from ##临时表名;

drop table #临时表名;
drop table ##临时表名;

drop table #Tmp   --删除临时表#Tmp
create table #Tmp --创建临时表#Tmp
(
    ID   int IDENTITY (1,1)     not null, --创建列ID,并且每次新增一条记录就会加1
    WokNo                varchar(50),   
    primary key (ID)      --定义ID为临时表#Tmp的主键      
);
Select * from #Tmp    --查询临时表的数据
truncate table #Tmp --清空临时表的所有数据和约束

IF object_id('tempdb..#jimmy') is not NULL BEGIN
DROP TABLE #jimmy;
END
SELECT * 
INTO #jimmy
FROM table
WHERE 1=1