Showing posts with label sproc. Show all posts
Showing posts with label sproc. Show all posts
Thursday, 30 October 2014
Check if a temporary table exist in as stored procedure
To check if a temporary table exist in as stored procedure use the following
if object_id(N'tempdb..#temp') is not null
Where #temp is your table
Then do something
if object_id(N'tempdb..#temp') is not null
drop table #temp
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...
-
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...