摘要:
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
阅读全文
posted @ 2021-03-16 14:26
平凡滴人
阅读(15)
推荐(0)
编辑
摘要:
-- 声明表变量 DECLARE @userTable TABLE (table_name NVARCHAR(20)); -- 将源表中的数据插入到表变量中 INSERT INTO @userTable(table_name) SELECT name FROM sysobjects WHERE xt
阅读全文
posted @ 2021-03-16 14:06
平凡滴人
阅读(183)
推荐(0)
编辑