dzw159

摘要： --批量插入（事先查询相对应的字段到临时表#temp1） SELECT ID,Name,Status INTO #temp1 FROM dbo.Doctor d WHERE d.ID NOT IN (SELECT ID FROM dbo.UP_Doctor) INSERT INTO dbo.UP_Doctor ( ID, Name, Status ) SELECT * FROM #temp... 阅读全文