create table newtablename(id [int] IDENTITY(1,1) NOT NULL,oldothercolumnlist) go insert into newtablename(oldothercolumnlist) select * from oldtable go
呵呵,还有主键!create table newtablename(id [int] IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED ,oldothercolumnlist) go insert into newtablename(oldothercolumnlist) select * from oldtable go
drop table oldtable go sp_rename newtablename,oldtable
如何用SQL语句设置超时时间?请指教
go
insert into newtablename(oldothercolumnlist) select * from oldtable
go
go
insert into newtablename(oldothercolumnlist) select * from oldtable
go
drop table oldtable
go
sp_rename newtablename,oldtable