Sorry, but there are no more tags available to filter with.
-
For a normal SQL table we will do the check in sysobjects similar to below, IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='tablename') Select ‘Exists’ We cannot do the same for temp tables and it can be done by, IF OBJECT_ID('tempdb..#temp') IS NOT NULL PRINT 'Exists' ELSE PRINT 'Not Exists...
Page 1 of 1 (1 items)