create table #TempIndex (
IndexID int identity (1, 1) not null ,
MessageID int
)
SET IDENTITY_INSERT #TempIndex ONinsert #TempIndex select * from BookMessage
IndexID int identity (1, 1) not null ,
MessageID int
)
SET IDENTITY_INSERT #TempIndex ONinsert #TempIndex select * from BookMessage
IndexID int identity (1, 1) not null ,
MessageID int
)
SET IDENTITY_INSERT #TempIndex ONinsert #TempIndex select * from BookMessageSET IDENTITY_INSERT #TempIndex OFF
不然你干脆不先建,用INTO生成临时表:
直接:
select * into #TempIndex from BookMessage
insert #tt(name) select 'aaa'
union all select 'eeee'
union all select 'bbbb'
select * from #tt
select * into #bb from #tt
select * from #bb
insert #TempIndex(MessageID) select MessageID from BookMessage
,MessageID=cast(MessageID as int)
into #TempIndex
from BookMessage
,cast(MessageID as int) as MessageID
into #TempIndex
from BookMessage
create table #TempIndex (
IndexID int identity (1, 1) not null ,
MessageID int
)
go
insert #TempIndex select MessageID from BookMessage
go-- 方法二(直接导入数据并且生成新表):
select identity(int,1,1) IndexID,cast(MessageID as int) MessageID
into #TempIndex from BookMessage
go