//执行存储过程,使能表复制功能
exec sp_dboption bxgjj, 'select into', 'true';
//bxgjj数据库名称
select * into test from gjj;
//复制表
编写表脚本为-》CREATE到文件
得到原始表的表结构,用文本编辑器修改表结构文件,为其添加主键以及主键约束:
1)主键
[id] [int] IDENTITY(1,1) NOT NULL,
2)主键约束
CONSTRAINT [PK_gjj] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
保存为新标SQL文件,执行,得到带主键的新表。
//为新表添加数据
insert into dbo.test (zgbh, zgxm, dwbh, dwmc, sfzh, gryce, dwyce, ycje, bnhj, bnzq, zhye, zgzt)
select zgbh,zgxm,dwbh,dwmc,sfzh,gryce,dwyce,ycje,bnhj,bnzq,zhye,zgzt from gjj;