sql两种临时表的创建

 if object_id('tempdb..#Temp_BU_Process','u') is null
begin
create table #Temp_BU_Process(
companyID int,
companyName nvarchar(200),
   processID int,
processCode nvarchar(200),
processName nvarchar(200),            
newRiskSize int,
updateRiskSize int,
newControlSize int,
            updateControlSize int,
updateLinkSize int
)
end else begin
delete from #Temp_BU_Process

end

=====================================

declare @tempTable table
(
id nvarchar(200) ,
name nvarchar(200)
)
insert into @tempTable
select userid,fullname from tbuser


select * from @tempTable