随笔分类 -  SQL

摘要：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 阅读全文

摘要：--创建存储过程 CREATE PROCEDURE TransferToHistory AS BEGIN --不返回计数 SET NOCOUNT ON; --开始捕捉异常 BEGIN TRY -- 声明配置表变量 DECLARE @config TABLE (id NVARCHAR(5)); --创建临时A表 CREATE TABLE #temp(id INT,t_a VARCHAR(15),t_ 阅读全文