摘要： DELETE A FROM book A JOIN ( SELECT MIN(id) id,authorID,bookName FROM book GROUP BY authorID,bookName HAVING COUNT(1) > 1 ) TMP ON A.authorID= TMP.auth 阅读全文

摘要： -- 声明表变量 DECLARE @userTable TABLE (table_name NVARCHAR(20)); -- 将源表中的数据插入到表变量中 INSERT INTO @userTable(table_name) SELECT name FROM sysobjects WHERE xt 阅读全文