Hi Guest 1 HomePage 1 Jobs 1 WalkIn 1Articles  

 :) Latest Topic
AJAX
VB.NET
SQL Query
UDDI
CLASS
JAVASCRIPT
SharePoint Interview
SilverLight
WCF
general knowledge
 ASP.NET
 :) Hot Jobs
 :) Latest Articles
 


  

 
Code to check and delete temporary table
Classified Posted on 30 Mar 2019

Home >> DataBase >> SQL Query >> Code to check and delete temporary table



Code to check and delete temporary table
Below is the code to check and delete the temporary table

IF object_id('tempdb..##temptable') IS NOT NULL
 BEGIN
  DROP TABLE ##temptable
  PRINT 'Temp table is deleted'
 END
Else
 BEGIN
  PRINT 'Temp table not exists'
 END


Other Important Questions
Syntax to rename a column
Query to get first day of month
replace null value to zero in sql
Update data using join
How to rename database







 
Top Searches:asp net questions vb net questions sql query uddl questions class javascript sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions
PHP | Biztalk | Testing | SAP | HR |