lyfz_repos/经典版源码/document/数据库维护脚本/将dindan表电话更新到client表.sql

USE [db]
-- 定义变量;
DECLARE @COUNT INT				-- 数量;
DECLARE @OrderId NVARCHAR(80)	-- 订单号;
DECLARE @Phone1 NVARCHAR(80)	-- 电话1;
DECLARE @Phone2 NVARCHAR(80)	-- 电话2;

-- 查询出所有订单的电话,并插入到临时表中;
SELECT IDENTITY(INT,1,1) AS AutoId, id, phone1, phone2 INTO #temp_dindan FROM dindan
-- 获取临时表最大ID;
SELECT @COUNT = MAX(AutoId) FROM #temp_dindan

-- 循环将dindan表里的订单电话更新到client对应的订单记录中;
WHILE @COUNT > 0
BEGIN
	SELECT @OrderId = id , @Phone1 = phone1, @Phone2 = phone2 FROM #temp_dindan WHERE AutoId = @COUNT
	UPDATE client SET phone1 = @Phone1, phone2 = @Phone2 WHERE id = @OrderId
	SET @COUNT = @COUNT -1
END

-- 最后,清除临时表;
DROP TABLE #temp_dindan