摘要: 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 阅读全文
posted @ 2012-09-21 15:51 pnljs 阅读(144) 评论(0) 推荐(0) 编辑