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...
-
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...
