declare @tbname varchar(30)
set @tbname='tmpTb'
set @tbname='tempdb..##' +@tbname
print @tbnameif ( object_id(@tbname) IS NOT NULL )
print '存在'
else
print '不存在'
set @tbname='tmpTb'
set @tbname='tempdb..##' +@tbname
print @tbnameif ( object_id(@tbname) IS NOT NULL )
print '存在'
else
print '不存在'
godeclare @tbname varchar(30)
set @tbname='tmpTb'
set @tbname='##' +@tbname
print @tbnameif exists(select 1 from tempdb..sysobjects where name=(select @tbname) and xtype='U')
print '存在'
else
print '不存在'
CREATE table ##tmpTb (Tbindex int)
godeclare @tbname varchar(30)
set @tbname='tmpTb'
set @tbname='##' +@tbname --你錯在這里了﹐多了几個單引號
print @tbnameif exists(select 1 from tempdb..sysobjects where name=@tbname and xtype='U')
print '存在'
else
print '不存在'
print '不存在'
else
print '存在'