cary〔卡里亚冰期〕

1：存储过程DELIMITER $$DROP PROCEDURE IF EXISTS test$$CREATE PROCEDURE test()BEGIN DECLARE xx INT DEFAULT 10000; while (xx>0) do set xx = xx-1;select xx; end while;    END$$DELIMITER ;执行：mysql>d...

1：打开'Ad Hoc Distributed Queries'exec sp_configure 'show advanced options',1reconfigureexec sp_configure 'Ad Hoc Distributed Queries',1reconfigure关闭只要将1设置为02：建立链路服务器EXEC sp_addlin...