BEGIN DECLARE ErrorCount int default 0 ; DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET ErrorCount = 1; SET @Temp = 0; WHILE @Temp <= 1000000 DO KILL @Temp; SET @Temp = @Temp + 1; END WHILE ; END
BEGIN DECLARE ErrorCount int default 0 ; DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET ErrorCount = 1; SET @Temp = 0; WHILE @Temp <= 1000000 DO KILL @Temp; SET @Temp = @Temp + 1; END WHILE ; END
转载于:https://www.cnblogs.com/liuxiaoji/p/7263214.html