求助:文本转化成数据库问题 急!!

create table #a1
(
id_num int IDENTITY(1,1),
作者 nvarchar(255)
)
go
insert into #a1
select 作者=substring(col001,6,254) from k1 where substring(col001,1,5)='【作　者】'

create table #a2
(
id_num int IDENTITY(1,1),
题名 nvarchar(255)
)
go
insert into #a2
select 题名=substring(col001,6,254) from k1 where substring(col001,1,5)='【题　名】'

create table #a3
(
id_num int IDENTITY(1,1),
刊名 nvarchar(255)
)
go
insert into #a3
select 刊名=substring(col001,6,254) from k1 where substring(col001,1,5)='【刊　名】'

select * from #a1
go
select * from #a2
go
select * from #a3

create table #a77
( id_num int IDENTITY(1,1),
题名 nvarchar(255) ,
作者 nvarchar(255) ,
刊名 nvarchar(255)
)
insert into #a77
select a.题名,b.作者,c.刊名
from #a2 as a inner join #a1 as b on a.id_num=b.id_num
inner join #a3 as c on b.id_num=c.id_num


版主,我是用上面的语句转化的,但是结果就错位了,请教下有没有好的方法啊

用得着这么麻烦吗?

create database 缘吇弹
go
use 缘吇弹
go
create table a(col1 char(255) primary key)
go
insert into a
values('【作　者】缘吇弹')
insert into a
values('【题　名】行列变换')
go
select 作者=substring((select * from a where substring(col1,1,5)='【作　者】'),6,254),
题名=substring((select * from a where substring(col1,1,5)='【题　名】'),6,254)
into b
select * from b
go

是啊,select 作者=substring((select * from a where substring(col1,1,5)='【作　者】'),6,254),
题名=substring((select * from a where substring(col1,1,5)='【题　名】'),6,254)
into b 只能插入一行，版主还有别的方法吧