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