笨
笨人
Unregistered / Unconfirmed
GUEST, unregistred user!
if exists(select * from tempdb..sysobjects where id=object_id('tempdb..#tmptable'))
drop table #tmptable
else
select f ,identity(int,1,1) as ff into #tmptable from tt
...
请问：tempdb..sysobjects 和 id=object_id 及identity(int,1,1)是何作用？
drop table #tmptable
else
select f ,identity(int,1,1) as ff into #tmptable from tt
...
请问：tempdb..sysobjects 和 id=object_id 及identity(int,1,1)是何作用？