Friday, 6 June 2014

Check if Temp table exists

To check if a temp table exists and if not create one use the following

IF OBJECT_ID('tempdb..#archive') IS NOT NULL
begin
 drop table #archive
end
else
begin

create table #archive(orderid int)


This checks to see if the temp table #archive exists and if it does them it drops it before recreating it

No comments:

Post a Comment

Multi Point USB Charger

  USB Plug Charger, 4-Port USB Fast Charger Plug with 33W Intelligent Quick Charge 3.0 Wall Charger, Multi USBPower Adapter UK Fast Charging...