--怎样创建临时并将相应数据填入？

[jeelan]

--怎样创建临时并将相应数据填入？
--有表BookMessage字段如下
create table BookMessage (
MessageID int identity (1, 1) not null ,
Content nvarchar(1000) null,
)

--怎样创建临时表#TempIndex并将BookMessage.MessageID填入
--该临时表的IndexID是自动计数的。
create table #TempIndex (
IndexID int identity (1, 1) not null ,
MessageID int
)
go

[zjcxc]

--一条语句就可以完成建表和赋值啦

select IndexID=identity(int,1,1)
,MessageID=cast(MessageID as int)
into #TempIndex
from BookMessage

[美丽心情]

学习，谢谢各位

[capcom]

select * into #TempIndex from BookMessage

[LoveSQL]

select identity(int,1,1) as IndexID
,cast(MessageID as int) as MessageID
into #TempIndex
from BookMessage

[gmlxf]

-- 方法一（先建表，后插入）：
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

[j9988]

create table #TempIndex (
IndexID int identity (1, 1) not null ,
MessageID int
)
SET IDENTITY_INSERT #TempIndex ON

insert #TempIndex select * from BookMessage

[j9988]

create table #TempIndex (
IndexID int identity (1, 1) not null ,
MessageID int
)
SET IDENTITY_INSERT #TempIndex ON

insert #TempIndex select * from BookMessage

SET IDENTITY_INSERT #TempIndex OFF


不然你干脆不先建，用INTO生成临时表：
直接：
select * into #TempIndex from BookMessage

[wzh1215]

create table #tt(id int identity(1,1),name varchar(20))
insert #tt(name) select 'aaa'
union all select 'eeee'
union all select 'bbbb'
select * from #tt
select * into #bb from #tt
select * from #bb

[j9988]

看错了，
insert #TempIndex(MessageID) select MessageID from BookMessage