SQLServer 临时表批量导入之存储过程

alter PROCEDURE DelTem
@authorName varchar(200)
as
declare @StockInID varchar(200)
begin

  insert into StockIn select distinct StreamLineID,WareHouseID,SupplyID,0 as 'state',@authorName from StockInDetailTem  
  --insert into StockInDetail select StreamLineID,WareHouseID,SupplyID,0 from StockInDetailTem 
end

exec DelTem 'maomao'