摘要:
CREATE TABLE Student ( ID int primary key identity, Name nvarchar(50) not null, Age int not null )CREATE TABLE Student_Temp ( ID int primary key, Name nvarchar(50) not null, Age int not null )--复制数据INSERT INTO Student_Temp(ID,Name,Age) SELECT ID,Name,Age FROM Student WHERE ID IN (1,2,3)UPDATE Studen 阅读全文