SQL 初始化数据

WHILE (1=1)
BEGIN
    UPDATE TOP(1000) [dbo].[PromotionCodeMaster] 
        SET CurrencyCode = CASE
            WHEN CountryCode='USA' THEN 'USD'
            WHEN CountryCode='CAN' THEN 'CAD'
            WHEN CountryCode='USB' THEN 'USD'
         END
        WHERE CurrencyCode IS NULL

    IF @@ROWCOUNT < 1000
    BREAK

    WAITFOR DELAY '00:00:10'
END