A strange error

生命舞者

declare @isWastage bit
declare @partcode varchar(20)

set @isWastage=1
set @PartCode='1234567890'

if @isWastage=1 --Requires the calculation result to include loss
   select fpartcode, dosage INTO #TMP2 from tbom007d where fparentpartcode = @PartCode
else
   select fpartcode, dosage*2 INTO #TMP2 from tbom007d where fparentpartcode = @PartCode --This line is wrong

The following error occurred:
Server: Message 2714, Level 16, State 1, Line 11
An object named'#TMP2' already exists in the database.

what happened? Thank you

我是杀人狂

declare @isWastage bit
declare @partcode varchar(20)

set @isWastage=1
set @PartCode='1234567890'

if @isWastage=1 --Requires the calculation result to include loss
   select fpartcode, dosage INTO #TMP1 from tbom007d where fparentpartcode = @PartCode
else
   select fpartcode, dosage*2 INTO #TMP2 from tbom007d where fparentpartcode = @PartCode

生命舞者

TO:我是杀人狂‵My ɡīr!.ˊI miss youˋ. (＊^_^＊)

  The purpose of the program is to insert different query results into a new table #TMP2 according to whether @isWastage is true.

  When @isWastage is true, I don't know why the statement behind the else is also executed

wgfxman

Add a judgment in front, if #TMP2 exists, just DROP it. . .

生命舞者

I added a drop table #TMP2　 in the first line, the result is the same, it doesn’t matter whether it is added or not

dream88

declare @isWastage bit
declare @partcode varchar(20)

set @isWastage=1
set @PartCode='1234567890'

if @isWastage=1 --Requires the calculation result to include loss
   begin
   if object_id(N'Tempdb..#TMP2') is not null dorp table #tmp2
   select fpartcode, dosage INTO #TMP2 from tbom007d where fparentpartcode = @PartCode
end
else
begin
   if object_id(N'Tempdb..#TMP2') is not null dorp table #tmp2

   select fpartcode, dosage*2 INTO #TMP2 from tbom007d where fparentpartcode = @PartCode
end - error on this line

我是杀人狂

if @isWastage=1
   insert into #tmp2 select fpartcode, dosage from tbom007d where fparentpartcode = @PartCode
else
   insert into #tmp2 select fpartcode, dosage*2 from tbom007d where fparentpartcode = @PartCode

生命舞者

Why is there an if conditional judgment, and the program still fails if the statement after the else is not executed?