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)
Passwords Made Easy
Today i thought i would write about password security. As we are all aware passwords are important but we continue to use very poor password...
-
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... -
If you have a situation that requires an application to always be up then try Restart program after a crash downloadable from https://w-s...
No comments:
Post a Comment