存储过程中遇到的问题
if not exists(select name from tempdb.sys.objects where name like '%#outtable%')
begin
if(select count(*) from CODE_Pcode_create where orderno=@ordernum and isout='10') !=0
begin
select itemtype as '类型',prats as '产品名称',count(*) as '已出库' into #outtable from CODE_Pcode_create where orderno=@ordernum and isout='10' group by itemtype,parts
end
else
begin
create table #outtable(类型 varchar(300),产品名称 varchar(300),已出库 int)
insert into #outtable(类型,产品名称,已出库) select distinct 产品名称,类型,0 from CODE_Pcode_create where orderno=@ordernum
end
end
else
drop table #outtable
总是提示#outable已存在