摘要：if exists (select * from dbo.sysobjects where id = object_id(N'#temp') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table #tempcreate table #temp( Pager2011_ID INT IDENTITY(1, 1) PRIMARY KEY , --索引，分页时根据这个字段来取记录 tableid varchar(20))Insert Into #temp(tableid)Select nationNoFrom tbl 阅读全文