关于sql 中导入数据时的自动增长列转换为一般列，导入后转换为自动增长列

 

if exists (select * from sysobjects where id = OBJECT_ID('[d_dbInfo]') and OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE [d_dbInfo] //判断该表是否已存在 ，存在 删除

//建表

CREATE TABLE [d_dbInfo] (
[id] [int]  IDENTITY (1, 1)  NOT NULL,
[d_dbname] [nvarchar]  (32) NULL,
[d_time] [datetime]  NULL)

 

//

ALTER TABLE [d_dbInfo] WITH NOCHECK ADD  CONSTRAINT [PK_d_dbInfo] PRIMARY KEY  NONCLUSTERED ( [id] )
//设置自动增长列关闭

SET IDENTITY_INSERT [d_dbInfo] ON

INSERT [d_dbInfo] ([id],[d_dbname],[d_time]) VALUES ( 1,'DB20110916184056.bak','2011-9-16 18:40:56')

//使用自动增长列

SET IDENTITY_INSERT [d_dbInfo] OFF