局部临时表

declare @test table(
id int,
name varchar(100)
)
insert into @test(id,name)
select ID,LastName from tb_OrderUserInfo where DATEDIFF(M,InTime,GETDATE())<3
select * from @test

原文地址:https://www.cnblogs.com/zhang9418hn/p/2303097.html