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
-
Labels: , , , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Chrome 138 the last supported

Chrome 138 the last supported  Hey Everyone, Chrome 138 is the last version of Chrome that will support Android 8.0 (Oreo) and Android 9.0 (...

  • Datepart in Crystal Reports
    Crystal Reports datepart is slightly different than  SQL and VB Interval type            Description yyyy                          Extr...
  • DCOB Fault
    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...
  • USB safe charging
      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...