實體表
Select * from syscolumns
where id=object_id(@tablename)
臨時表
Select * From tempdb..syscolumns
where id=object_id('tempdb..'+@tablename)
Select * from syscolumns
where id=object_id(@tablename)
臨時表
Select * From tempdb..syscolumns
where id=object_id('tempdb..'+@tablename)
print '#t1临时表已存在'
else
print '#t1临时表不存在'
where id=object_id('tempdb..#T1')
)
print '存在'
else
print '不存在'
print 'yes'
else
print 'no'
Select * from syscolumns where id=object_id(@tablename)
临时表
Select * From tempdb..syscolumns where id=object_id('tempdb..'+@tablename)这个已经问过很多次了,建议你最好先查询一下,也许会更快的解决问题。好运
begin
......
end