alter table article alter columns int identity(1,1)
1.在sql2005里建linkedserver连接access数据库,2.将其表数据 select * into #t from linkserver...[access表名] 存为sql server的临时表, 3.select * into [正式表名] from #t4.alter table [正式表名] alter column [字段名] [类型]5.insert into [正式表名]([字段列表]) select [字段列表] from #t
存为sql server的临时表, 3.select * into [正式表名] from #t4.alter table [正式表名] alter column [字段名] [类型]5.insert into [正式表名]([字段列表]) select [字段列表] from #t