Sql query syntax error

See more:

SQL

SQL-Server

Hi Team,

I need to insert data in TableA from below query and the Insert and Select should run as single statement , But I am getting error says 'Incorrect syntax near If' for below query.
What is wrong here?

Thanks in advance.

Insert into TableA (Col1, Col2, Col3, Col4)

IF Object_ID ('temp..#Temp') Is not Null
Drop Table #Temp
Create Table #Temp
(
 ColA Varchar (100),
 ColB Int
)

Insert into #Temp
Select ColA, ColB from TableB

Select Col1, Col2, Col3, Col4
From TableC C
Inner join #Temp T On C.Col1=T.ColB

What I have tried:

I tried using braces also , But did not work.