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
Showing posts with label drop table. Show all posts
Showing posts with label drop table. Show all posts
Friday, 6 June 2014
Subscribe to:
Posts (Atom)
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...
-
USB Plug Charger, 4-Port USB Fast Charger Plug with 33W Intelligent Quick Charge 3.0 Wall Charger, Multi USBPower Adapter UK Fast Charging...
-
Today, emergencies happen often. Below is a list of emergency supplies that you should have available. This list is not made in stone. For...
-
If you have a Samsung phone or pad and the keyboard is set to Google give the Samsung one a try. Just go into the keyboard settings and...