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)
-
Crystal Reports datepart is slightly different than SQL and VB Interval type Description yyyy Extr...
-
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... -
Do you charge your device in a public or on a non secure work space ? if the answer is yes then you are leaving your device open to be hac...
No comments:
Post a Comment