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
Subscribe to:
Post Comments (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...
-
If DCOB Fault comes on your main phone this means that there is no external lines available and you will need to call you service pro...
-
Today, emergencies happen often. Below is a list of emergency supplies that you should have available. This list is not made in stone. For...
-
Crystal Reports datepart is slightly different than SQL and VB Interval type Description yyyy Extr...
No comments:
Post a Comment